req :Mackro for removal for emplyspaces in cells ?

  • Thread starter -[::::Shamran::::]-
  • Start date
S

-[::::Shamran::::]-

I is possibly to make a mackro that deletes emply spaced in a range og cells
like A1:A120?

Regards
Shamran
 
S

-[::::Shamran::::]-

-[::::Shamran::::]- said:
I is possibly to make a mackro that deletes emply spaced in a range og
cells like A1:A120?
Click to expand...

Sorry for the inconvenience .. DOH !
One just have to think an make a seek/replace macro looking for a " " and
replaceing it with nothing ... sorry

Shamran
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Runtime error 1004 when trying to insert formula in cells 11
Drawn Objects Q 2
error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error 7
Setting row height to 0 in the visible celss of a range 1
datediff in excel 2003.. Agecalculation 5
Excel Conditional Formatting Removal 7
Macros 2

Top