Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Need to use VBA select all the blank cells, one column to the right of
a column which has a variable range. example: Have values in a column, B3:B10. Need to select C3:C10. The column B range size changes all the time, but always starts in cell B3, and can range from 50-500 cells.. I'll be entering formulas in column C, and don't want to enter any formulas where there isn't a value in column B, so, it necessitates chosing only the blanks that has a value preceeding it, in column B. Have located lots of VBA relative navigation codes, but none that will select this column. TIA for any ideas. Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter and selection question | Excel Discussion (Misc queries) | |||
Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
Range Selection | Excel Discussion (Misc queries) | |||
A cell selection question | Excel Discussion (Misc queries) |