Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i find the last specific value in a column? | Excel Discussion (Misc queries) | |||
Find specific column and copy row. | Excel Programming | |||
Find specific column titles and copy the column to new workboo | Excel Programming | |||
Find specific column titles and copy the column to new workboo | Excel Programming | |||
find a specific value in a column and write another column | Excel Discussion (Misc queries) |