need help with VBA syntax

I'm new to VBA and writing macros, and I'm not familiar with the proper syntax for generating my own code. I would really appreciate some help with this, it would make life a lot easier if I could write a macro to do what I'm currently doing with formulas.

Lets say I'm using the following formula, which I have pasted all down column D. Based on whatever row we've pasted this into, were going to see whats in column B, then check whats in column C, then check to see if I2 contains anything (this is a box I use to switch between metric and standard), and based on all this criteria, we output something like:

whateverswritteninB3 (0.000)

Please Login or Register  to view this content.

I'd like to do this in VBA, and while I dont know the proper syntax, the way I'm thinking about it in my head is:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Just make sure the formula works, which it didn't and then record a macro.

Put the cursor in the cell with the formula, press F2 to go into edit mode, press Enter to confirm the formula and stop the recording.

What you get is raw code but I've tidied it up a bit.


Regards

I'm really not sure what you are trying to achieve, but the basic code is:

Please Login or Register  to view this content.

And:

Please Login or Register  to view this content.

is:

Please Login or Register  to view this content.

Do what you will with the string result.

Regards