Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell selection in non-active sheet
Excel 2002, WinXP
All the following relates to doing this in VBA. If I paste something to say, A3:D3, then A3:D3 of that sheet is highlighted in blue. If I want to get rid of the blue highlight, and make A1 the active cell on that sheet, and that sheet is the active sheet, all I have to do is select A1. Question: How can I make this happen when that sheet is not the active sheet, short of selecting that sheet first? Thanks for your help. Otto |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell selection in non-active sheet
I assume you want to copy paste
and not show what you'ce copied thrue the selection.. use syntax like Range("sheet1!a3:d3").copy Range("sheet2!a4:d4") and there's no need to (re)select any cells :) keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Otto Moehrbach" wrote: Excel 2002, WinXP All the following relates to doing this in VBA. If I paste something to say, A3:D3, then A3:D3 of that sheet is highlighted in blue. If I want to get rid of the blue highlight, and make A1 the active cell on that sheet, and that sheet is the active sheet, all I have to do is select A1. Question: How can I make this happen when that sheet is not the active sheet, short of selecting that sheet first? Thanks for your help. Otto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
jump to active cell in other sheet . | Excel Discussion (Misc queries) | |||
Selection starting from active cell | Excel Discussion (Misc queries) | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
Using the Active cell in one sheet for another sheet | Excel Discussion (Misc queries) | |||
Determining the Selection on a non-active Sheet? | Excel Programming |