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