depends on what is in your variables
MyRows = 132343
EndColumn = "D4"
would provide what you show.
if endcolumn = 4 then
PivotRange = Range("C" & myRows & ":D" & endColumn)
--
Regards,
Tom Ogilvy
"Ctech" wrote in
message ...
VBA CODE:
PivotRange = Range("C" & myRows & ":" & endColumn)
QUESTION:
Is this VBA code wrong to get the example below
*i.e. *
PivotRange = Range("C12343:D4")
--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=475452