All
I am trying to use the code below to select a worksheet as follows
My Worksheet is named B and My String called Choice is "=B*"
I was trying the code below
[VBA] Worksheets(Mid(Choice, 1, 2)).Cells.ClearContents
rng.SpecialCells(xlCellTypeVisible).EntireRow.Copy _
Worksheets(Mid(Choice, 1, 2)).Range("A1")[/VBA]
Can anyone tell me my error please
Thanks
Gibbo