LinkBack URL
About LinkBacks
Hi,
For example, my range is C2.
If i set my current column like:
Mycolumn would be C
Mycolumn = ActiveCell.Column
If i would like to copy Range C2:C37, so Mycolumn2:mycolumn37.
How should i program this?
Hi,
For example, my range is C2.
If i set my current column like:
Mycolumn would be CMycolumn = ActiveCell.Column
If i would like to copy Range C2:C37, so Mycolumn2:mycolumn37.
How should i program this?
Here are two ways to reference the range
note that mycolumn is a number, not a letterRange(Cells(2, mycolumn), Cells(37, mycolumn)) Cells(2, mycolumn).Resize(36, 1)
If you are pleased with a member's answer then use the Star icon to rate it.
Yes, thanks!!
That's what i needed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks