Thread: How can I replace a formula with its result using a macro?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
RAP RAP is offline
external usenet poster
  
Posts: 49
Default How can I replace a formula with its result using a macro?
One more question, if you please.

On this line:
Set rng = ActiveSheet.Range("A20:K20")
What would I insert to go from the active sheet to another sheet in the
workbook?

Thank you,
Randy
Reply With QuoteReply With Quote