MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.