| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing spaces from value using VBA
I need to define a value for rangename. I have this working so far:
rangename = Workbooks(curbook).Worksheets(datasheet).Range("a" & i).Value Debug.Print rangename Unfortunately, the range name has SPACES in it and when I use it to create a named range, it GACKS. How do I remove the spaces from this? Thanks, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Spaces | Excel Discussion (Misc queries) | |||
| removing all spaces | Excel Discussion (Misc queries) | |||
| Removing spaces from cells not possible? | Excel Discussion (Misc queries) | |||
| REMOVING TRAILING SPACES | Excel Discussion (Misc queries) | |||
| removing spaces | Excel Discussion (Misc queries) | |||
Threaded Mode
