Need help on this macro
I need to add someone to this macro-it is working correctlky (Iam brand new
at writing them), but I need to add one more thing and cannot figure it out. I need to tell it to stop when it gets to text. I cannot tell it to only read numeric because after the text are more numbers that I do not want. So how do I tell it to read the numeric, but stop when it gets to text in the first sentence of this macro? Thanks! Range("I" & Range("Restraints").Row).End(xlToLeft).Select Sheets("RESTRAINTS").Range("B5").Value = ActiveCell.Value |
Need help on this macro
So are you saying that your data looks like this
1 22 32 bb 44 and you want to stop on bb or are you saying you data looks like this 123rt 765u 789p456 and you want just the numbers up to rt then up to U and finally up to p? Or are you saying that you data looks like this 3243 54 765y 655 4432 and you want to stop on 765y? -- If this helps, please click the Yes button Cheers, Shane Devenshire "Paula" wrote: I need to add someone to this macro-it is working correctlky (Iam brand new at writing them), but I need to add one more thing and cannot figure it out. I need to tell it to stop when it gets to text. I cannot tell it to only read numeric because after the text are more numbers that I do not want. So how do I tell it to read the numeric, but stop when it gets to text in the first sentence of this macro? Thanks! Range("I" & Range("Restraints").Row).End(xlToLeft).Select Sheets("RESTRAINTS").Range("B5").Value = ActiveCell.Value |
All times are GMT +1. The time now is 09:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com