robinbernett
asked on
vba to fill down formulae just in rows that hold data
I have a block of data in cols A-H, rows 2-n, row 1 contains headers. Row2, cols I - T contain formulae. Using vba I want to fill down the formuae for as many rows as have data only. Could someone help with some code please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Robin,
Thanks for the points and grade.
It depends what you are after, really. Most VBA books tend to be geared towards a specific host application (e.g. Excel or Word) because that is more practical. For Excel I would recommend anything by John Walkenbach or any of the Bovey/Bullen/Green Wrox Press books on Excel VBA. The Getz / Gilbert VBA Developers Handbook is also very good indeed once you get into the swing of things (there's a lot of advanced stuff in there) - from the same series as the must-have Access Developer references.
A couple of links here purely so you know which ones I am talking about:
http://www.amazon.com/Excel-2003-Power-Programming-VBA/dp/0764540726/sr=8-1/qid=1164032502/ref=pd_bbs_sr_1/104-6818050-1540740?ie=UTF8&s=books
http://www.amazon.com/VBA-Developers-Handbook-2nd-Getz/dp/0782129781/sr=8-2/qid=1164032502/ref=pd_bbs_sr_2/104-6818050-1540740?ie=UTF8&s=books
http://www.amazon.com/Excel-2003-Programmers-Reference-Programmer/dp/0764556606/sr=8-14/qid=1164032502/ref=sr_1_14/104-6818050-1540740?ie=UTF8&s=books
http://www.amazon.com/Professional-Excel-Development-Applications-Addison-Wesley/dp/0321262506/sr=8-7/qid=1164032502/ref=pd_bbs_sr_7/104-6818050-1540740?ie=UTF8&s=books
The last one is probably a bit more than most people are interested in, but I think it's great!
HTH
Rory
Thanks for the points and grade.
It depends what you are after, really. Most VBA books tend to be geared towards a specific host application (e.g. Excel or Word) because that is more practical. For Excel I would recommend anything by John Walkenbach or any of the Bovey/Bullen/Green Wrox Press books on Excel VBA. The Getz / Gilbert VBA Developers Handbook is also very good indeed once you get into the swing of things (there's a lot of advanced stuff in there) - from the same series as the must-have Access Developer references.
A couple of links here purely so you know which ones I am talking about:
http://www.amazon.com/Excel-2003-Power-Programming-VBA/dp/0764540726/sr=8-1/qid=1164032502/ref=pd_bbs_sr_1/104-6818050-1540740?ie=UTF8&s=books
http://www.amazon.com/VBA-Developers-Handbook-2nd-Getz/dp/0782129781/sr=8-2/qid=1164032502/ref=pd_bbs_sr_2/104-6818050-1540740?ie=UTF8&s=books
http://www.amazon.com/Excel-2003-Programmers-Reference-Programmer/dp/0764556606/sr=8-14/qid=1164032502/ref=sr_1_14/104-6818050-1540740?ie=UTF8&s=books
http://www.amazon.com/Professional-Excel-Development-Applications-Addison-Wesley/dp/0321262506/sr=8-7/qid=1164032502/ref=pd_bbs_sr_7/104-6818050-1540740?ie=UTF8&s=books
The last one is probably a bit more than most people are interested in, but I think it's great!
HTH
Rory
ASKER
That looks great. I could have cobbled something together, but I want to try to learn 'proper' code.
btw is there a vba manual you could recommend?
Many thanks for your help. Points on their way!
Robin