k3vsmith
Member
I have VBA code that is working but is hard coded for a worksheet that has a set number of rows. Now the # of rows is going to be ever changing and I want to use a range rather than hard coded cells.
Can you explain how to create a range.
Range on entire working sheet (from first cell in column to last used cell in column and first cell in row to last cell in row that is used)
Range on a particular column (used column)
Dim wRange as Range
Set wRange = ?
Thanks in advance.
Can you explain how to create a range.
Range on entire working sheet (from first cell in column to last used cell in column and first cell in row to last cell in row that is used)
Range on a particular column (used column)
Dim wRange as Range
Set wRange = ?
Thanks in advance.
