VBA - Using RANGE function - Feeding Parms Problem

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:

Please Login or Register  to view this content.

Here is what I have thus far (it all works except being able to put something into the range):

Please Login or Register  to view this content.

Edited to reflect the code tags

Try this instead

Please Login or Register  to view this content.

Thanks for the quick reply I tried that before, and I copied and pasted what you put to be sure that I didn't fat finger it. This is the error msg that I get:

Runtime error 1004
Method 'Range' of object '_Global' failed


I tried this and finally got it:
Range("F3:F" & RowsCounted).Formula = "=ROUND((RC[4]/RC[-1]),0)"

Originally Posted by mrice

Try this instead

Please Login or Register  to view this content.