I have attached a ss where i am trying to select the current region. i cannot use current selection due to the empty column(B)
How can i select this data.
The columns stay the same but the rows are variable.
I cannot simply use Columns("A:G").select as i am appending to another workbook