Hi there
I'm wanted to sum all values between two variables which I have set as firstrow and last row. I have been playing around with a line of code to do this but cannot figure it out:
I know the code below is incorrect but I can't see how I would accomplish what I want:
Please Login or Register to view this content.
Any ideas would be great
Hi,
Like this:
DomPlease Login or Register to view this content.
Last edited by romperstomper; 07-15-2011 at 06:32 AM.
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Other way with formulaR1C1
Best RegardsPlease Login or Register to view this content.
MaczaQ
change to
Please Login or Register to view this content.
hi guys, working great! thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks