LinkBack URL
About LinkBacks
I have a macro that runs well until it hits this line
Then I get a Run time error 438 - Object doesn't support this property or method.
Please Login or Register to view this content.
Anyone know what I'm doing wrong here?
I have a macro that runs well until it hits this line
Then I get a Run time error 438 - Object doesn't support this property or method.Please Login or Register to view this content.
Anyone know what I'm doing wrong here?
Last edited by bibleguy125; 02-15-2012 at 12:59 PM.
You've spelt Formula wrong.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Looks ok to me, but I'm a little dyslectic. It is that darn VB Editor has all these reserved words and knows how to spell.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Pesky marcos
Dom
Wow, that is awesome. Thanks for catching it. I probably would have missed that for a long time.
Debugging and using Option Explicit would have highlighted the error
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
It highlighted it when I debugged, but it was the whole line and I still missed the fact that I had misspelled formula. I changed it this morning and everything works great.
As Roy suggests though having Option Explicit set would have prevented such misspelling and highlighted the problem for you as you entered your code. Not only that but it forces you to declare any variables that you might be using which is also good practise.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks