| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select C6 down to last used cell, as determined in column B
Column B ALWAYS has entries in each cell.
The entries in B always go to bottom of used range on worksheet. Once last cell is determined, need to select Column C6 down to last cell, in order to process the following code. ' Select C6 down to last used row Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=($B6=""*"")" Selection.FormatConditions(1).Interior.ColorIndex = 4 any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
| Find DMIN in a column range determined by a number in another cell | Excel Worksheet Functions | |||
| Column value for row = fiscal quarter (determined by date field) | Excel Discussion (Misc queries) | |||
| Look up sheet name determined in cell | Excel Programming | |||
| Determined to eliminate .select | Excel Programming | |||
Threaded Mode
