Thread: Help with Dynamically changing Range in Excel Macro
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
runsrealfast runsrealfast is offline
external usenet poster
  
Posts: 14
Default Help with Dynamically changing Range in Excel Macro
On Jul 16, 2:56 pm, "Bob Phillips" wrote:
NumRows = 1006
Range("R2").FormulaR1C1 = "=VALUE(RC[-1])"
Range("R2").AutoFill Destination:=Range("R2:R" & NumRows)


BTW. I tested it and it worked.

Thanks

John


Reply With QuoteReply With Quote