View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harry Tuttle Harry Tuttle is offline
external usenet poster
 
Posts: 4
Default Removing 1st four rows from a range

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!!