| 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 |
| 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 | |||
Threaded Mode
