Hi everyone, this is my first post, so I wanted to start out saying "He
there!" I'm 22, have done minor programming with HTML, PHP, etc, Acces
and Excel now being my interests, so I thought I'd get a question out o
the way that has been bugging me for the better part of the day.

What I have is a list of data in excel, going from A4:CX (x bein
variable, as it changes daily how long this list is). I want to writ
a macro that will count how many items are in that range, and then su
the items in C4:CX. I don't know how to let VBA know how many row
contain data, so that's where my trouble right now is coming from. I
someone could step me in the right direction, I should be able t
figure out the summing and counting from there.

Thanks, and I'm glad to be here :o

--
Martin_Austi
-----------------------------------------------------------------------
Martin_Austin's Profile: http://www.excelforum.com/member.php...fo&userid=1638
View this thread: http://www.excelforum.com/showthread.php?threadid=27755