DA,
I have a question with the following problem.
I would like to divide two numbers (stored as Double), but also would like to keep them separately in the cell, so when you select the cell you can see: "=12,33/1,2342" (example)
Dim T4ANumerator As Double
Dim T4ADominator As Double
T4ASheet.Activate
T4ANumerator = T4ASheet.Range(T4ANumeratorCell).Value
T4ASheet.Range(T4ANumeratorCell).Select
'msgbox testing that T4ANumarator is having the value I needed
MsgBox T4ANumerator
T4ADominator = T4ASheet.Range(T4ADominatorCell).Value
T4ASheet.Range(T4ADominatorCell).Select
'Same as before
MsgBox T4ADominator
T4BSheet.Activate
T4BCell.Select
'This is the line where I have the error
T4BCell.Value = "=" & T4ANumerator + "/" & T4ADominator
Thank you for your help in advance.
BR,
Daniel
Bookmarks