deleting blanks and commas

		Microsoft Office Forums > Microsoft Excel > Excel Programming
deleting blanks and commas

FAQ

Thread Tools

Display Modes

#13

03-06-2017, 03:52 PM

NoSparks

Windows 7 64bit deleting blanks and commas

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Code:

With Sheets("CCCCCCC")
    .Activate '<~~ makes sure right sheet is active
    ActiveCell.Offset(1, 0).Select  'move 1 row down, 0 columns over
    .Rows(ActiveCell.Row).Insert Shift:=xlDown
    Sheets("DATA ENTRY").Range("A3:Z3").Copy .Range("A" & ActiveCell.Row)
End With

Standing by for next revision

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 AM.