Selecting a cell from user input

[Taff]

Hi,
first time poster here, although Ive found numerous answers already.

Im trying to select a cell from a users input, and so far have put this together:

Please Login or Register  to view this content.

However this line is causing me no end of problems with the syntax, Ive tried numerous things as above or

Please Login or Register  to view this content.

But I cant seem to find it.

Its my first day at this in case you havent gathered, so any help would be cool.

Taff

[Leith Ross]

Hello Taff,

You are trying to assign an object (the range on the worksheet) to a non existant object variable - Area1. You need to declare Area1 in a Dim statement.

Example:
Dim Area1 As Worksheet

Now the assignment will work and the system will recognize Area1 as a Range on the worksheet "VBA".

Have fun,
Leith Ross

[Taff]

Hi Leith and thanks for your reply.

For some reason, Im getting a compile error now, saying it cant find the method or data object and marking interior. Thats a rough translation from the german OS I am using, here is the code now:

Please Login or Register  to view this content.

Grateful for any further help I can get!

Taff

[Taff]

Hi again,
after inwardly digesting Leiths post, and some experiments, it would appear that I have it where I want it.
For others attempting something similar, here is the solution:

Please Login or Register  to view this content.

Thanks again Leith,

Taff