Hello,

I have some VBA code that sends data to an Excel 2000 Spreadsheet.
This data can vary in rows, sometimes 10 rows, sometimes 1000 rows.

In the VBA, I want to apply the following formula in column X to each
row:

477*Q2 <-----that would be for row 2

Then for row 3, same forumla, but Q3....etc etc.

Can someone help me out with some code.

Thanks!

-brian