$$Excel-Macros$$ Re: Macro for Userform

Answering a couple of questions should help you. If you were going to do this in worksheets, would you use a vlookup? Do you know how to write a vlookup in VBA to get it to populate the form? Do you know how to send and receive values from one sub/function/form to another? Have you considered plac

$$Excel-Macros$$ Re: copy row

For currentRow = firstRow to lastRow If cells(currentRow, 1).value >1 then Rows(currentRow).copy Rows(currentRow+1).select Selection.paste lastrow = lastrow +1 end if Next currentRow Rajesh - you will need to dim currentRow, firstRow and lastRow as integers o

$$Excel-Macros$$ Re: breaking links

To break the links, record yourself doing a find and find next. Search for [ Put that in a loop. Insert in the code a copy, paste special value for that cell and then search for the next one. Eventually, the loop will end when it can't find [ Or if you are advanced enough in VBA you can use the s

Re: $$Excel-Macros$$ Pivot table not showing

Hi, This file is shared. you will have to remove this.. Go to Tools-> share work book-> uncheck the ' allow changes' -> ok Regards, Mathan On Thu, Jun 17, 2010 at 11:29 AM, Deepak Rawat wrote: > Hi friends, > > I got an excel file, in which pivot table option is disable and not > working.

$$Excel-Macros$$ Delete line and take to another tab upon cell entr

So I have a file where a task/person responsible etc. is listed When the task is completed, I would like to enter yes and upon this text entry, the file would delete that line and add it to another tab with other completed tasks. Task Person Complete? RFP Jane Doe -- --

Re: $$Excel-Macros$$ Help...Vlook up

Thanks you. I try your suggestion and give both cell the same format but still I get # N/A. The cell I am refering contains the function =CONCATENATE(C2;D2) and even when I use the FIND function I get VALUE NOT FOUND evenso I know for sure the value exist. On Wed, Jun 16, 2010 at 2:27 PM, Paul Sc

$$Excel-Macros$$ Sparklines and MicroCharts

All: I have attached a micro chart utilizing a UDF from the website: http://www.dailydoseofexcel.com/archives/2006/02/05/in-cell-charting/ Is there a way to make the graph more sensitive to the data? It just looks like a straight line. Thanks Michael -- -

$$Excel-Macros$$ Excel hours and minutes calculation *********URGENT **********

Hi dave, In the same way If I want to know the exact number of working hours between 19:45 PM yesterday and 16:50PM today ( Considering the user is working in second shift from 15:00 PM to 00:00 AM ). Thanks & Regards, On Thu, Jun 17, 2010 at 7:33 AM, who wrote: > Hi, > Below starts in Cell A1

$$Excel-Macros$$ activate sum display function

Hey Guys, I need help in a matter While using excel ,the sum is displayed below when we select a particular range of cells.But i m able to view count instead of sum on selection of a particular range of cells.How to rectify this ? - -- --

$$Excel-Macros$$ Trouble putting picture in activecell

-Original Message- From: Jim [mailto:sch...@gmail.com] Sent: Thursday, June 17, 2010 12:27 AM To: excel vba Subject: Inserted Picture Doesn't Display I'm inserting a picture in the selected cell; I see a flicker of the cell border on insertion but the picture doesn't end up in the cell.

Re: $$Excel-Macros$$ How to display cell contects as password *****

Hi, You can use an alternate way to over come this. change the text color of cell to same as background then lock and hide it. After this protect the sheet. Thanks and Regards Sandeep. On Tue, Jun 15, 2010 at 10:45 AM, Rajesh Bedse wrote: > thx Vikas. > > The issue with this formatting is tha