View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Newman Ken Newman is offline
external usenet poster
 
Posts: 1
Default 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