Hello community,
I am using VBA to find first and last row number which I want to copy.
Problem is I can't figure out how to add columns to this range.
Example:
Startrow = 5
endrow = 17
And I want to copy from B5:Q17, how can I do that?
Tried = "B" & startrow : "Q" & endrow , but I guess I did something wrong.
ActiveSheet.Range(startrow & ":" & endrow).Copy
If anyone can help me, thanks in advance..
I am using VBA to find first and last row number which I want to copy.
Problem is I can't figure out how to add columns to this range.
Example:
Startrow = 5
endrow = 17
And I want to copy from B5:Q17, how can I do that?
Tried = "B" & startrow : "Q" & endrow , but I guess I did something wrong.
ActiveSheet.Range(startrow & ":" & endrow).Copy
If anyone can help me, thanks in advance..