Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select the contents of a cell
Hi to All,
I have a macro to sort a table which produces a variable array that I also want the macro to format. Alongside this array I have a formula in cell R5 which produces a self-updating text string identifying the array to be formatted. For example, after sorting, cell R5 contents = "C7:M15" (the variable array). The result of the formula in R5 will change each time the macro is run so that it always defines the dimensions of variable array that I want to format. How can I get the macro to select the contents of cell R5 as the array to be operated on? I've found heaps of examples of how a macro can write to a cell but nothing on how a macro can read from a cell . . . Thanks if you can help and please don't assume I know a-n-y-t-h-i-n-g Cheers, RonW. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to select a Row based on contents of a Cell | Excel Programming | |||
How do I select & use contents of first non-blank cell in row? | Excel Worksheet Functions | |||
select cell at random and delete contents | Excel Programming | |||
select contents of cell | Excel Programming | |||
select a cell based on A1 contents | Excel Programming |