Hi All
I have the following code which populates a listbox on UserForm initialize. Column G and I are formated as percentage. I am trying to get the listbox to populate with those columns as two decimals....I keep getting a runtime time error 13 Type mismatch.
Error on these two lines of code...Can anyone please advise
Please Login or Register to view this content.
Please Login or Register to view this content.
By the way...The rows of Column G And I contain formula's...Could this be causing the problem
Not to worry all...Deleted formulas and now am populationg sheet with VBA formula's
The presence of formulas is not the problem, my guess is that those formulas are returning strings rather than numbers.
Adding the VAL function to the code in the OP should prevent the error
Or, if the formula might return an error value (e.g. #DIV/0)Please Login or Register to view this content.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks