No, right and left arrows do skip hidden columns, but this isn't the case
with offset.
? ActiveCell.Offset(0,1).EntireColumn.Hidden
True
--
Regards,
Tom Ogilvy
"Raman325" wrote in
message ...
Thanks for the responses. Yeah, I haven't been using range as the
variable name, I just used that as the example. That is exactly how I
had my macro set up, but it is still not going through the worksheet
correctly. I was playing around with the worksheet, moving left and
right with the arrow keys, and for some reason, its skipping over
columns. Why is it doing that? The right and left arrows arent working
as they should and I suspect that's what is causing the problem with
the offset.
--
Raman325
------------------------------------------------------------------------
Raman325's Profile:
http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=396202