| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH
Hi,
To fiil a selected cell with 35 spaces - try to run this MAcro: ========== Sub SP() ActiveCell = Space(35) End Sub ======= Michael Avidan - ISRAEL http://forums.tapuz.co.il/office "CHARI" wrote: IN EXCEL, HOW DO I SHOW A CELL THAT IS EMPTY AS HAVING IT FILLED WITH SPACES AND HAVING A PARTICULAR LENGTH (FOR EXAMPLE 35). I NEED THIS FOR A CLIPBOARD AND IF THE DOESN'T COUNT THE SPACES, IT THROWS OFF THE POSITION OF THE NEXT CELL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| leave a cell blank | Excel Worksheet Functions | |||
| blank cell turns to 0 | New Users to Excel | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
