Divide the values of 2 integer variables?

  • Thread starter Thread starter LongBeachGuy
  • Start date Start date
L

LongBeachGuy

Divide the values of 2 integer variables?
I am trying to do this:

ActiveCell.FormulaR1C1 = "=The_Current_Cell_Data_Row/
The_Largest_Value_In_Column"

but it does not give me a value.
It gives me "#Name?" in the cell I am working on.

What an I doing wrong?
 
If The_Current_Cell_Data_Row and The_Largest_Value_In_Column are
variables (rather than names in the workbook), then one way:

ActiveCell.Value = The_Current_Cell_Data_Row / _
The_Largest_Value_In_Column
 
If The_Current_Cell_Data_Row and The_Largest_Value_In_Column are
variables (rather than names in the workbook), then one way:

ActiveCell.Value = The_Current_Cell_Data_Row / _
The_Largest_Value_In_Column






- Show quoted text -

THANK YOU SO MUCH!!! YOUR EITHER AN ANGEL OR GOD HIMSELF!!!!
I have been on this problem since 6 AM today!!! IT is 6 PM now.

THANK YOU, THANK YOU,THANK YOU, THANK YOU, THANK YOU, THANK YOU,THANK
YOU, THANK YOU,!!!!

Jose
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top