deleting blanks and commas

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 12:30 PM.