Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transporting Variable from macro to spreadsheet
I have calculated a variable 'n' in a macro and want to put it into a
spreadsheet. The expression ActiveCell.Formula = "= Max(R3Cn:R3C256)" doesn't work, although substituting a number for n does work Any solutions would be appreciated -- Ken |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transporting Variable from macro to spreadsheet
Ken,
Try something like ActiveCell.Formula = "= Max(R3C" & N & ":R3C256)" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Ken Newman" wrote in message ... I have calculated a variable 'n' in a macro and want to put it into a spreadsheet. The expression ActiveCell.Formula = "= Max(R3Cn:R3C256)" doesn't work, although substituting a number for n does work Any solutions would be appreciated -- Ken |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transporting Variable from macro to spreadsheet
Although Chip's line of code may work, I bet he meant:
ActiveCell.FormulaR1C1 = "= Max(R3C" & N & ":R3C256)" Chip Pearson wrote: Ken, Try something like ActiveCell.Formula = "= Max(R3C" & N & ":R3C256)" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Ken Newman" wrote in message ... I have calculated a variable 'n' in a macro and want to put it into a spreadsheet. The expression ActiveCell.Formula = "= Max(R3Cn:R3C256)" doesn't work, although substituting a number for n does work Any solutions would be appreciated -- Ken -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable data from one spreadsheet sent to new spreadsheet | New Users to Excel | |||
Running a variable macro when any value is entered into a variable cell | Excel Programming | |||
Looking up blank cells and transporting data to another worksheet | Excel Programming | |||
Use row number in spreadsheet as variable in macro | Excel Programming | |||
Transporting a toolbar within a spreadsheet | Excel Programming |