Problem Inserting Value Into Cell

[StevenRK72]

Below is code that completely works... with the exception of line highligeted in Red. I get a run-time error 1004. I've tried every thing with my very limited VBA knowlege. Help!
Steve

Please Login or Register  to view this content.

[6StringJazzer]

Can you attach a sample file so we can reproduce the error?

Is the sheet "elevate pricing" protected?

Also there is no need to Activate each sheet, although that is not causing your error. I would remove all of those lines. In the one case where you refer to ActiveSheet, refer directly to the sheet of interest rather than using Activate/ActiveSheet.

Also you have two unqualified Range references that should be explicitly qualified (but that is not causing the runtime error).

Please Login or Register  to view this content.

[StevenRK72]

Attache is file I'm using...

BSB Elevate Quote v4.xlsm

[6StringJazzer]

The code in your file is not what you showed in your post. In the file there are illegal "curly" quote marks

Please Login or Register  to view this content.

When I fix that it works.

Please Login or Register  to view this content.

[StevenRK72]

6StringJazzer, Sorry for the run around. While the code appeared to look correct, there must have been some corruption in the line. After you mentioned, I deleted the line and re-typed it in completely...now mine works as well. i will review your first comments to see if I can correct those as well.

BTW...does your call name indicate guitar? I have 45+ guitars.

Thansk for your help! Steve

[6StringJazzer]

I pointed out the problem with that line of code. Instead of using " " marks it was using the kind of quotes marks you find in Microsoft Word “ ” . These are not recognized by VBA as quotes. I just changed those two characters and it worked for me.



I am a jazz guitarist. However, I do not have 45 guitars! I have:

Sadowski Jim Hall
Eastman AR910-CE
Hofner New President
PRS 22 something
1974 ES-335-TDC
MIM Telecaster
Takamine nylon string