Greetings, Gurus.
Suppose I am using auto filter on a range to filter down to only the blank cells in column C, and then I want to enter a formula into all those blank cells. How would I determine the range of the first blank cell? Here's what I have so far:
Thanks in advance for any help you can offer.
Please Login or Register to view this content.
Last edited by hutch@edge.net; 05-05-2010 at 11:40 AM.
Hi, Could you use this, The "Specialcells" function will Give you the addresses of the Blank Cells, and then next line will fill them with th Formula.
Regards MickPlease Login or Register to view this content.
Thanks for the reply, Mick. When I tried your code, I got the following error:
Run-time error '1004': No cells were found. The debug highlighted the following line:
Set Rng = Rng.SpecialCells(xlCellTypeBlanks)
Yes, there are blank cells in the range.
Last edited by hutch@edge.net; 05-04-2010 at 11:48 AM.
Hi, I know this sounds rather obvious but, I can only suggest you try the code on a new sheet.
Place data in column "C", then Delete some of the values.
See what the code returns.
Regards Mick
Sorry so slow to repond, Mick. I had to leave the office early yesterday.
I figured out the problem. The reason your script isn't finding any empty cells is because of the line:
It is telling it to only look in cells that already contain data. How would I chnage that line to look at all cells in column C, down to the last row in column A. I triedPlease Login or Register to view this content.
but I get a "Method 'Range' of object '_Global' failed" error.Please Login or Register to view this content.
Hi, Try :-
Regards MickPlease Login or Register to view this content.
Perfect! Here's the final code as I use it:
Thanks, Mick. Have a good one.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks