VBA Code Referencing a cell

Hi,

I am trying to reference a cell in a Macro which changes to a named person in the Excel file every time I use a lookup table. The Macro references the name of the person but I want it to reference a particular cell in Excel instead of the persons name, this way, when the excel file is changed to a different person's named data, I don't get an error when running the macro. At the moment, i am getting around the problem by typing the name of the person in the VBA code and then running the macro.

At the moment the VBA code displays this


Sheets("John Smith").Select


Can I put something instead of "John Smith" in the VBA code which will mean I don't get an error when running the macro, for example a reference to the cell which contains the name of the person in the excel file?

Many thanks

Please Login or Register  to view this content.

You're welcome and thanks for rep+.