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

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

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