| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column number of last column that returns value ignore formulas
If Len(.Cells(3, i).Value) 0 Then or try it with Lcol = 23 - WorksheetFunction.CountBlank(Range("A3:W3")) Regards Claus B. Thanks, Claus. Will give it a go. Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Numbers in Column, Leave Formulas in Column Intact | New Users to Excel | |||
| Copy column, paste special formulas & number formats doesn't work | Excel Discussion (Misc queries) | |||
| Index with mulitple value returns and muliple column returns | Excel Worksheet Functions | |||
| highest # in a column A & returns answer from column B Formula | Excel Discussion (Misc queries) | |||
| Ignore zero in column for subtotal | Excel Discussion (Misc queries) | |||
Threaded Mode
