Thread: How do I Address A Worksheet From A Cell Reference?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
georgef georgef is offline
external usenet poster
  
Posts: 8
Default How do I Address A Worksheet From A Cell Reference?
The following was generated by the macro recorder:

Sheets("project01").Select
Range("HL5:HZ8").Select
Selection.Copy
Sheets("Report").Select
Range("DR502:EF505").Select
ActiveSheet.Paste

I need to be able to select the sheet that I am copying things from based on
a cell value. For example, cell A1 could have "project06" or "project22" at
any given time when this macro runs. How do I accomplish this "indirect"
addressing? i.e., can I somehow use something like "Sheets("cell
A1").Select"? (I am not a VB programmer.)

Thank you.
George
Reply With QuoteReply With Quote