View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ToniS ToniS is offline
external usenet poster
 
Posts: 18
Default Find a Specific Column

I have source code in place to find the lastcolumn, how do I decrement 3 or 4
columns... for example lastcolumn = "$H$4" I want to specify a range of
"$E$4:$h$4" I am basically adding 3 columns and later on will like to select
the range of columns just added to do additional programming on. Below is
how I set my lastcol variable

For Each cell In Range(Range("A4"), Range("IV4"))
LastCol = cell.Address

If cell = Empty Then
Exit Sub
End If
Next cell


Any help is greatly appreciated
ToniS