Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding NExt Blank Cell in Range
I received an answer to my last question and I have to say
first off, I am alway aprreciative of everybody who takes the time to answer and I respect and admire your programming skills. My problem this time is as follows I want to check a range (b2 to Z2) and I want to find the first blank cell, once that cell is found I want it to check a cell from the menu sheet and if there is something in the cell insert it in the first blank cell ie I enter YR 2005 in cell G22 on the menu sheet, then when I look at sheet 2 it checks the range and when it comes across the first blank cell it inserts that value Thanks Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding the position of the i-th non blank cell in a vertical range | Excel Worksheet Functions | |||
Finding Next Blank Cell in Blank Row | Excel Worksheet Functions | |||
Finding the bottom non-blank cell in a range | Excel Discussion (Misc queries) | |||
Finding next blank cell | Excel Programming | |||
Finding the Blank Cell | Excel Programming |