| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple "Left" Problem
Hi everyone
I have a long Macro in one of my excel file and I am getting an object defined error. " Searchvalue = .Left(Range("A" & sh2rowcount), 9) " I wanted my searchvaule to be left of that range. This is just a part of my code and everything looks good except that line. Where do I insert Left ? in order to search first 9 values of Range("A" & sh2rowcount)?? Please help Thank you, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a problem with "LEFT" formula | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Problem: Worksheets("New Style 2006").Unprotect Password:="naPrint" | Excel Programming | |||
| Conflict with "Right" / "Left" Command | Excel Programming | |||
Threaded Mode
