I would like to get a column range (the first column) from a range, example: If the Range: $E$9:$I$259 The result : $E$9:$E259
How could I achieve this?
By using the columns collection of the range object like so:
Range("$E$9:$I$259").Columns(1)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With