T
ToniS
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
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