I am trying to do something I thought would be fairly simple, but is causing me quite a bit of headache! I need to use vba to go to a sheet in an open workbook, start at the top of the data, (usually row 2), select all the data in the column and insert a sum at the bottom. This is really easy to do manually, but I can't get the code to reproduce it.
'totals
Dim nextCell As Variant
Range("C1").Select
Selection.End(xlDown).Select
nextCell = ActiveCell.Offset(1, 0).Row
nextCell.Select
ActiveCell.FormulaR1C1 = "=SUM(R[-832]C:R[-1]C)"
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.