Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current region emulation | Excel Worksheet Functions | |||
Sort doesn't recognize current region | Excel Worksheet Functions | |||
Copy Current Region | Excel Programming | |||
Naming Current Region | Excel Programming |