Copy & Paste
Posted by Brian on January 30, 2001 8:11 AM
This is probabbly the most simple problem ever posted, but I can't figure it out. I have a macro that creates a copy of a worksheet. I want to rename the worksheet to what is input in a cell on a third page. I used the record macro to try to do this. i noticed that it stores the actual contents of the cell that I copied instead of just copy the active cell then paste it.
Posted by Carl on January 30, 2001 8:25 AM
To name the active worksheet based on the value of cell A1 on the 3rd sheet:
ActiveSheet.Name = Sheets(3).Range("A1").Value
Posted by Brian on January 30, 2001 10:33 AM
This sounds close, but the actual cell location will be changing that names the worksheets. This will prevent me from using a cell location like "A1". Thanks though.
