Hi guys,
Trying select a range from a point x in a column to the the last empty cell above it.
I think I need another variable to count how many rows I have gone down but can't get my head quite around how to achieve this.
As you can see in the sample book i am trying to quickly fill in the above rows in the column.
Please Login or Register to view this content.
Thanks in advance for your time and help!
D
Last edited by dems; 09-10-2010 at 07:29 AM.
Please Login or Register to view this content.
I'm not following... could you please explain how this is supposed to work?Originally Posted by snb
Please Login or Register to view this content.
What did you notice during testing ?
Removal of the header row autofilter and changed the text in cell J1 to J from text
Please Login or Register to view this content.
This seems to add another "J" after the last non-empty cellPlease Login or Register to view this content.
I may not have explained myself clearly. I am trying to fill the empty cells in column D with first number encountered when going down the range -
i.e. D6 = "2" so D2:D5 would = "2"
D15 = "3" so D7:D:14 = "3"
As far as I can see all the cells in column D are empty....
Well dont I look stupid... apologies mate, correct book attached.
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