Hi All!
I am desperately trying to add a simple subtotal formula but receive the same error ("Type mismatch"):
Thankful for all your help!Please Login or Register to view this content.
//Jenny
Hi All!
I am desperately trying to add a simple subtotal formula but receive the same error ("Type mismatch"):
Thankful for all your help!Please Login or Register to view this content.
//Jenny
Last edited by jennyc2; 05-04-2009 at 09:34 AM.
You should be using either Range("A1") or Cells(1,1)
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks for your reply!
You were right that it was the first problem, although I still haven't gotten the subtotal to work. More simple formulas are added, like this:
But when it is a formula slightly more complicated, like IF or SUBTOTAL, I get an error:Please Login or Register to view this content.
-> Application defined or object defined error (same with the first example in my original post)Please Login or Register to view this content.
//J
Shouldn't this be:
, instead of ;Please Login or Register to view this content.
Yes, how odd - the "," where made into ";" when they ended up on the sheet. Thank you thank you thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks