Hello!
I wanted to know how I can manipulate only the number within a cell using VBA
For example, if a user writes >=5 in the cell, it should multiply the number by 10,000 and show as >=50000. Similarly =2.5 should show up as =25000.
I tried
Set rng = ThisWorkbook.Sheets("Automated Data").Range("B2:B13")
For Each c In rng
c.Value = c.Value / 1000
Next
I assume I get an error because of the text in it, so I'd like to know how to work around that.
Thanks in advance!
try:
Please Login or Register to view this content.
Thanks for the quick response Roel! Unfortunately, that doesn't work.
FYI, I changed the code to IsNumeric instead of IsNumber since the latter gave an error. Is there something else I'm supposed to include when using IsNumber?
I'm sorry I used the worksheetfunction (isnumber) instead of the VBA specific testfunction (IsNumeric) for this.. I simply confused the two..
you cloud add worksheetfunction.isnumber(c.value) then it will work, but in general use the VBA function in VBA.
Last edited by Roel Jongman; 02-23-2019 at 03:44 AM.
Or extract the numbers.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanks Roel and bakerman!
You're welcome and thanks for rep+.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks