how to subtract a range from another?
One way:
Dim rng As Range
Set rng = Range(Cells(5, 1), Cells(Rows.Count, 1))
MsgBox rng.Address
Hope this helps
Rowan
serdar wrote:
say i wanna set a range of an entire column "minus" first 4 rows. How to do
this in VBA?
|