error 1004 select method of range class failed

**Lee_wwfc** · 03-23-2013, 11:35 AM

Hi my code is not working but looks correct please have a look, I have debugged it and put the bit which it told me to correct in green below:

Please Login or Register  to view this content.

**Norie** · 03-23-2013, 11:58 AM

Do you actually need that line?

Instead of using ActiveCell in the next line use friPrice.

PS Please edit your post to add code tags.

**Lee_wwfc** · 03-23-2013, 12:06 PM

Thankyou

soo much it has worked

Lee

**Norie** · 03-23-2013, 12:21 PM

This should work as long as you have numeric data in column D.

Please Login or Register  to view this content.

**Lee_wwfc** · 03-23-2013, 12:33 PM

Thankyou it has worked and you have fixed my system haha thankyou :D

**Lee_wwfc** · 03-23-2013, 12:34 PM

Hi i wonder if you also know how to do this below : :D

I am making a seating plan which first you have to select a row A-L then you need to select
a seat but there are different numbers of seats within the rows so when i book a seat in row A
and select seat 20 it comes up as an error as it doesn't exist but how do i enable a message box to appear instead
saying 'sorry this seat does not exist' If you know how to do this please would you tell me.
Thankyou :D