How do you set a variable to equal the value of a cell?

I have ran into an issue when trying to set a variable to equal the value of a particular cell. The code I have written for it is shown below:

Please Login or Register  to view this content.

I am trying to use the ActiveCell.Offset command because the cell that I am want the value from isn't always L1225. (Depending on user input)>

Thank you for the help.

When the macro runs, a user is asked if information on sheet 1 is relevant; if yes, the information on that sheet is copied and pasted to the current sheet (CODESHEET UNSORTED). There are 15 sheets prompted and each one can be answered yes or no.

At the bottom of the CODESHEET UNSORTED, all of the copied data is summed and the values are compared to a bid summary sheet to make sure the user didn't forget to include any sheets with information on them.

That is what this will eventually be used for (conditional formatting to ensure the values match) but I can't figure out how to set that value as a variable to use throughout the conditional formatting.

Does this help?

Please Login or Register  to view this content.

I changed the code I had :

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

And it still errors with 'identifier under cursor is no recognized'.

Did you activate the sheet first?

I didn't before because I thought it had already been the 'active sheet.'

I just activated the sheet and it worked.

What does that command do? I thought that I wouldn't need it because I was already on CODESHEET UNSORTED prior to starting that command line.

Thank you for the help.

You're welcome, glad to help out and thanks for the feedback. Most likely your workbook has several sheets. Each sheet would then have an activecell (the last cell you worked on with that sheet). You have to identify which activecell you are refering too, so you need to activate the sheet when you used activecell.

I see, thanks again for the help - I'm nearly finished with this macro now!