Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select the current region excluding the top row
Hi
I want to select the current region excluding the top row The following did not work Selection.CurrentRegion.Resize(-1, 0).Select Can someone help me ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select the current region excluding the top row
This assumes you have only 1 Row as your header if that changes just change
the 1 to however many rows you need as your header. Sub SelectRange() Dim myRange As Range Set myRange = ActiveCell.CurrentRegion myRange.Offset(1, 0).Resize(myRange.Rows.Count - 1, myRange.Columns.Count).Select End Sub Hope this helps! If so, please give us credit. -- Cheers, Ryan "DZ" wrote: Hi I want to select the current region excluding the top row The following did not work Selection.CurrentRegion.Resize(-1, 0).Select Can someone help me ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Current region emulation | Excel Worksheet Functions | |||
looping through current region | Excel Programming | |||
Select current region and print | Excel Programming | |||
Select current region less one column | Excel Programming | |||
Copy Current Region | Excel Programming |