I have a 100x100 spreadsheet to which I paste data from another workbook using a macro. After the paste has been carried out, the entire recipient WS is shaded (selected). I would like to select a single cell in this WS so that the entire WS is not left selected. Here's the code I have tried, for which I get the error "Select method of range class failed" (1004). ("Sh" is a string that id's the sheet to be used in WB B; e.g. Sheet6.)
Rng1.Copy ' from WB A
Rng1P.PasteSpecial xlPasteValuesAndNumberFormats 'to WB B
Workbooks("WB B.xlsm").Sheets(Sh).Range("T4").Select
Application.CutCopyMode = False
Without the Select statement, the macro works just fine.
Even if I use something like:
Workbooks("WB B.xlsm").Sheets(Sh).Range("T4")=1
the macro will place a 1 in T4, but the whole sheet is still highlighted.
Is there another way to unselect the cells that have been pasted into WB B?
Thanks for your help, from a newbie.
Rng1.Copy ' from WB A
Rng1P.PasteSpecial xlPasteValuesAndNumberFormats 'to WB B
Workbooks("WB B.xlsm").Sheets(Sh).Range("T4").Select
Application.CutCopyMode = False
Without the Select statement, the macro works just fine.
Even if I use something like:
Workbooks("WB B.xlsm").Sheets(Sh).Range("T4")=1
the macro will place a 1 in T4, but the whole sheet is still highlighted.
Is there another way to unselect the cells that have been pasted into WB B?
Thanks for your help, from a newbie.