Forum Discussion
VBA Row.Address syntax
Hoping someone can help with my reference/method/argument in VBA. Had my first Workbook Event macros functioning until i wanted to improve it. Goal is to have it update column E with a formula for ...
You don't need RowStart and RowEnd.
And you shouldn't enclose StartRange and RowRange in quotes.
RowRange = Range("A" & Rows.Count).End(xlUp).Row
StartRange = Range("E" & Rows.Count).End(xlUp).Row
Range("E" & StartRange & ":E" & RowRange).FillDown
- good lord... if there's one thing i've learned in attempting VBA, it's that things are usually simpler than I make it. I always have a hard time figuring out what is unnecessary.... Thank you!
