MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"capturing" an address?


Posted by Bill on December 12, 1999 9:23 AM

Range("A1:A4").Select
Selection.Cut
Sheets("Sheet2").Select
ActiveSheet.Paste
Columns("A:A").Select
Selection.Insert Shift:=xlToRight
Sheets("Sheet1").Select
Range("A1").Select
End Sub

How might I modify the module above so that it
looks at sheet1 cell B2 and select a sheet with
the same name ? ( cell B2 changes daily)
I've done this in Quattro Pro using &"****"&
in my formulas but havent found a solution in Excel, hope you can give me a clue.


Thank You

Bill


Posted by Marcus Macrae on December 13, 1999 8:02 AM

Bill, I've changed your third line to select the right sheet

- Marcus How might I modify the module above so that it