Calling a formula within a VBA sub

[enswitze]

I want to use the RIGHT formula in my sub.

Right now this is what I have -

Please Login or Register  to view this content.

As you can see - I have labelled 2 different sheets different things (rooms and data) however, it won't let me use the RIGHT formula on the information from Data because it says there is a syntax error and has the line:

Please Login or Register  to view this content.

highlighted in red.

Does anyone know a way I can fix this?

[Marcol]

Please wrap your code in code tags, before the moderators get you...

Forum rules

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.

Cheers

[enswitze]

thanks... sorry about that!

[Marcol]

Change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Because you have "RIGHT(Worksheet("Data").Cell(RowChanger, 1), 3)" in quotes this is read as a string, not a function.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.