Jumat, 03 April 2015

I have always created my dynamic ranged manually. Now I would need to make it programmatically.

I have found following code, but there are so many syntax lines that I have never used

Am I too lazy? Or still too beginner?

I would like to see something simpler: Create a dynamic name on only one sheet for only one column, but I am not sure what to take off. I guess I would need only the code between: If cl.Value <> "" Then ... End If

---------------------------------- Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.