Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Could someone please tell me if there is an elegant way include all of
collums G-L minus the first 4 rows in a range. I can select all of columns G-L with something like: Dim priCol as Range Set priCol = ActiveSheet().Range("G1:L1").EntireColumn Then I would like to be able to remove just the first 4 rows from this range. I can kludge it by using the the 'usedRange.address' properties like this: dim secCol as Range Set rusedRange = ActiveSheet().UsedRange sAddress = rusedRange.Address pos = InStr(1, sAddress, ":", vbTextCompare) sAddress = Mid(sAddress, pos, Len(sAddress)) Set secCol = ActiveSheet().Range("G4" & sAddress) secCol.Select However I feel that this way is inelegant, and that there is probably a better way. Could someone please point me to this better way. -Many Thanks!! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Range("g5", Range("l5").End(xlDown)).Select
mcg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing duplicate rows | New Users to Excel | |||
Removing duplicate rows | Excel Discussion (Misc queries) | |||
Removing unwanted rows | Excel Worksheet Functions | |||
Removing Empty Rows and selecting Specific Rows | Excel Programming | |||
Removing Duplicate Rows | Excel Discussion (Misc queries) |