| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find
Dear All,
How can i find the columnnumber of the first empty cell starting from cell M7 To be used in a loop. M is fix but 7 is variable. Thank³ Filip |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find
You can try this. It heads left from column IV back until it runs into the
first populated cell and then move one column to the right... dim lngLastColumn as long lngLastColumn = cells(7, columns.count).end(xlToLeft).offset(0,1).Row -- HTH... Jim Thomlinson "Filips Benoit" wrote: Dear All, How can i find the columnnumber of the first empty cell starting from cell M7 To be used in a loop. M is fix but 7 is variable. Thank³ Filip |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
| find and delete text, find a 10-digit number and put it in a textbox | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
Linear Mode
