something along these lines should work (or at least get you going in the
right direction )

Sub copyrange()
Dim rngMyRange As Range
Set rngMyRange = Worksheets("Customer Information").Range("AG3:AS3")
rngMyRange.Copy
Sheets("Bill").Activate
Cells(28, 1).Select
ActiveSheet.Paste
End Sub


"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