Quote:
Originally Posted by Claus Busch
Hi,
Am Tue, 25 Mar 2014 01:21:58 +0000 schrieb sumesh56:
I made a selection of a range in one sheet and went to another sheet
click on R3 cell to where i wanted the display .before doing that i have
edited the macro 'A1' to R3. the message is
Runtime error '9'
Subscript out of range.
make your selection to copy and run the macro. Don't go to another
sheet.
Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Prodessional
|
[quote]make your selection to copy and run the macro. Don't go to another
sheet.[quote]
[color=blue]but that is what i wanted. i shall make a selection in one sheet and go to another sheet click on a cell and then run the macro. i should get the result displayed from the cell.[color=blue]