P
Patrick Molloy
Dim rTable As Range
Dim WS As Worksheet
Set WS = ActiveSheet
Set rTable = WS.Cells.CurrentRegion
Now you have rTable in memory referencing the sheet
region. Don't forget that you can manipulate data easily
without necessarily having the sheet active nor the cells
selected. The code above works whatever sheet is active.
Patrick Molloy
Microsoft Excel MVP
Dim WS As Worksheet
Set WS = ActiveSheet
Set rTable = WS.Cells.CurrentRegion
Now you have rTable in memory referencing the sheet
region. Don't forget that you can manipulate data easily
without necessarily having the sheet active nor the cells
selected. The code above works whatever sheet is active.
Patrick Molloy
Microsoft Excel MVP