Select current region less one column
 

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

Select current region less one column
 

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


--
Don Guillett
SalesAid Software

"Soniya" wrote in message
...
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