Nevermind :) I found my error. I left the reference to XcolB in the last
term., when I removed the "B" it worked great :)

See, I told you it had to be my error .... Thanks a LOT!

"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
figured i'd give you the entire code to show how i did it

Sub test()
Dim xcol As String
Dim cltop As Long
Dim clbot As Long
xcol = "K"
cltop = 5
clbot = 8
Set chrtrange = Range("B" & cltop & ":B" & clbot & "," & xcol & cltop &
":" & _
xcol & clbot)