|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
September 16th, 2003, 04:48 AM
|
|||
|
|||
Excel Macro
I need a macro that will search a large excel spreadsheet for blank cells (cells with nothing in them) and delete them and moving the cells to the right of the blank cell to the left. Can anyone help please?
|
|
#2
September 25th, 2003, 04:27 PM
|
|||
|
|||
|
I had a similer problem,
What I did was recorded a macro for deleting one space and shifting the data, then went into the vba code and just copied it over for about 12,000 lines.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Excel Macro |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
