Hi Guys,
Can someone enlighten me for this, why is my code error when i want to put a value on the new sheet that i just add.
The error is on the line below
Runtime Error 13 , type mismatch is what show up.
Please Login or Register to view this content.
Thanks in advance for the help.Please Login or Register to view this content.
Try this...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi,
Are you trying to add and reference a sheet called Ticker in these lines of code?
If so, you need some quote marks..Please Login or Register to view this content.
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Try:
Please Login or Register to view this content.
Wow...can't believe i didnt try that...hahaha..Thanks Guys!!
Works great with Ticker.value , thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks