|
|
#5
03-01-2017, 12:43 PM
|
|||
|
|||
Hey..... stop with that old man stuff, I'm an Old Age Pensioner too ya know.
 Except for the 33 and HorizontalAlignment this is what I had prior to seeing your last post. xlBlanks is an built in constant. In the vba environment, place your cursor within SpecialCells and hit F1 to find out things like this. You could remove the commas to make those cells blank, then delete. Code:
With Range("A33", Cells(Rows.Count, "A").End(xlUp))
.Replace What:=",", Replacement:=""
.SpecialCells(xlBlanks).Delete Shift:=xlUp
.HorizontalAlignment = xlRight
End With
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| pivot not showing number format with commas | olybobo | Excel | 1 | 05-05-2016 05:09 PM |
 Counting Blanks in 1 Column and Non-Blanks in Another
|
dogwood705 | Excel | 4 | 02-07-2015 08:45 AM |
| Commas within fields in .csv files | gar | Excel | 1 | 01-29-2015 09:24 PM |
|
How to use mid or left functions to seperate city,st,zip with no commas
|
sinaranje | Excel | 4 | 11-11-2014 10:52 PM |
|
No inverted commas in word 2013.
|
tonycrossley | Word | 3 | 01-27-2014 04:55 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode