I have searched here and I found some threads which I thought might help but after trying I came up empty so I figured I'd start one and put my code up.
I've gone from Green Screen Programming back to the GUI side and now have to learn the VBA for EXCEL....
Task: On a worksheet which has a dynamically changing # of rows, insert 2 columns, set their width, and insert a formula into the range.
- For example if there are 30 rows the variable RowsCounted will house 30. If there are 20,000 then RowsCounted will have the value of 20,000. I want to say Range("F3:RowsCounted".Formula = "FormulaGoesHere"
Here is the specific line which is giving me problems:
Here is what I have thus far (it all works except being able to put something into the range):
Edited to reflect the code tags
Bookmarks