Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a used / filled column
Is there a way to wtite a VB that will look for a column that is used
/ filled? I.E. Colums A4, B4, C4 and D4 are empty. It will skips the empty columns until it finds and selects an used / filled column, in this case column E4. Ogopogo5 *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a used / filled column
this code assumes that the empty cells are not formulas returning empty
strings... dim rng as range set rng = range("a4") if isempty(rng) then set rng = rng.end(xltoright) rng.select -- HTH... Jim Thomlinson "ogopogo5" wrote: Is there a way to wtite a VB that will look for a column that is used / filled? I.E. Colums A4, B4, C4 and D4 are empty. It will skips the empty columns until it finds and selects an used / filled column, in this case column E4. Ogopogo5 *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a used / filled column
Hi Jim
I copied and pasted the VB and it works. Thank you very much for helping out. Ogopogo5 *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a used / filled column | Excel Programming | |||
Finding a used / filled rows | Excel Programming | |||
go to last filled cell in a column shortcut | Excel Worksheet Functions | |||
Last Filled Column | Excel Programming | |||
finding the no. of rows in a COL filled with numbers, zeros and bl | Excel Worksheet Functions |