Select current region less one column

  • Thread starter Thread starter Soniya
  • Start date Start date
S

Soniya

Hi all,

I have data in my sheet1 in column F thru F (starting
from row 3, row 2 being column heading.

I want to print various reports based on aurofilter
crieteria of column A. since my column A item have been
added to page header i want to print the selection
starting from column B thru F

How can do useing macro?

TIA
Soniya
 
From HELP indec for currentregion

Sub currentregionlesstoprow()'ROW
'Range("b1").CurrentRegion.Select
Set tbl = ActiveCell.CurrentRegion
tbl.Offset(1, 0).Resize(tbl.Rows.Count - 1, _
tbl.Columns.Count).Select
End Sub
======
'modified
Sub currentregionlessleftcolumn()'COLUMN
Set tbl = ActiveCell.CurrentRegion
tbl.Offset(0, 1).Resize(tbl.Rows.Count, _
tbl.Columns.Count - 1).Select
End Sub
 
Back
Top