Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell References and Ranges
At the moment I use the following code to set the format for cells on my
worksheet Range("B2").Select Selection.RowHeight = 60 With Selection.Font .Name = "Akzidenz-Grotesk Std Regular" .Size = 24 End With I would like to change the code so that instead of "B2" I use "Cells(2, 2)". However a straight replace doesn;t work. Any Suggestions? I can see how to replace |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Unable to replace cell references with Named ranges | Excel Discussion (Misc queries) | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
Named ranges: don't want absolute references | Excel Discussion (Misc queries) | |||
Named ranges: don't want absolute references | Excel Discussion (Misc queries) |