Tocogroup
asked on
Why does my VBA macro generate an error on a Select command ?
Hi Experts,
I'm developing a small Excel application which prompts the user to enter name, organisation and email address and then populates cells with these values on a sheet.
However, after the input, I'm getting a 'Run time error 1004 Select method of Range class failed' when I select the sheet to display.
I've attached the application.
Any ideas anyone ?
Thanks
Toco
TNA-Test-3.xlsm
I'm developing a small Excel application which prompts the user to enter name, organisation and email address and then populates cells with these values on a sheet.
However, after the input, I'm getting a 'Run time error 1004 Select method of Range class failed' when I select the sheet to display.
I've attached the application.
Any ideas anyone ?
Thanks
Toco
TNA-Test-3.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry for my input I didn't see your reply we crossed by 3 minutes.
gowflow
gowflow
ASKER
Thanks both of you for your responses. It's such a basic error of mine......you can tell I'm still a rookie.
Not sure what I do here. I've been criticised before for not sharing the points.
What do you suggest ?
Not sure what I do here. I've been criticised before for not sharing the points.
What do you suggest ?
no problem for me you can allocate to Andrew all of it my pleasure to help. not here for points
gowflow
gowflow
ASKER
Many thanks gowflow. Much appreciated.
ASKER
Thanks for the help
Toco
Toco
Thanks gowflow.
gowflow
TNA-Test-3.xlsm