Any idea what I am doing wrong with this code? This is what I am trying to attempt:Please Login or Register to view this content.
If rowNum = 3 then:
Cells(3,6) = WorksheetFunction.Sum(Range("A3:E2"))
I get a run time error 13, type mismatch.
Any idea what I am doing wrong with this code? This is what I am trying to attempt:Please Login or Register to view this content.
If rowNum = 3 then:
Cells(3,6) = WorksheetFunction.Sum(Range("A3:E2"))
I get a run time error 13, type mismatch.
Replace + with &
Entia non sunt multiplicanda sine necessitate
Change all the plus (+) signs to ampersands (&).
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks