To initialize some cells/ranges, I am copying a given range and pasting it to another given range using the .Copy and .PaseSpecial methods.
However, it would seem that both methods actually select the range(s) for the operations, i.e. the given ranges(s) are activated/selected thus changing the focus on the spreadsheet.
I would like to perform both operations without actually selecting the given ranges ... what is the (obvious) way to do so?
Thanks,
Last edited by hmissoumi; 10-03-2008 at 01:35 PM.
Don't select:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
I am NOT selecting the Ranges: the .Copy method will move the focus to the range I want to copy ... AND that is what I want to avoid.
Same for the .Pastespecial method
More precisely, I do no want to move away from the currently active cell.
Hello hmissoumi,
Here is an example that will copy the values from a range on Sheet1 to a range on Sheet2. The cell formats and formulas are not copied, just the values. The active cell remains untouched on both sheets.
Sincerely,Please Login or Register to view this content.
Leith Ross
Shg's code does not select any cell so the whatever cell is active will remain active.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks Ross, that will do ... I have to use xRange.value = yRange.value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks