Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions |