Copy contents of Range to other cell
I'm confused
"Al" wrote in message
...
Please help! I have a spreadsheet that lists, in a cell,
the Worksheet/Range of pertinent information that I want
to use. I want to be able to store this Worksheet/Range
in a variable and then use it to copy the information that
is located within that Worksheet/Range into a cell.
ie. the originating cell has:
'Customer Information'!AG3:AS3 (store this in a
variable) and copy the information that is located at that
location to the target worksheet/cell: 'Bill'!A28
In other words, I don't want 'Customer Information'!
AG3:AS3 in the target cell, I want the information
contained in that range copied to the target cell.
I want to use VBA to code this if possible? Thank you in
advance for any help you can provide.
Al
|