Is there a macro variable code that will allow the variable to look at Text and read it like a number?
I have numbers that are placed in my spread sheet as Text, and I need to get an Average of a small group of them. I have tried converting them to numbers, but that causes errors for other macros.
Please Login or Register to view this content.
Last edited by CityMPLSEmpolyee; 10-01-2010 at 03:56 PM.
You can convert them in the code using the CLng, CInt, CDbl, and CSng functions. For more info see the Type Conversion Functions in the VBA help.
Assuming one of your numbers written as text is in cell A1, it'd look like this:
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Thank you
I'll try this
this is what I have
Please Login or Register to view this content.
Last edited by shg; 10-01-2010 at 04:03 PM. Reason: fix code tags
The numbers that I am trying to work with are pasted in and they have spaces included with them from the original source.
I ran your code above on some cells with numbers formatted as text and it worked as expected. If it is not working for you could you post a sample worksheet with some numbers that you are not able to average?
Try this instead:
Please Login or Register to view this content.
How do I post a sample
excellent it worked perfect.
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