deleting blanks and commas

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

FAQ

Thread Tools

Display Modes

#11

03-01-2017, 09:36 PM

FUGMAN

Windows 10 deleting blanks and commas

Office 2016

Banned

Join Date: Feb 2017

Posts: 55

this how I get the data from sheet one to sheet 2

Dim sht2 As Worksheet
Set sht2 = Sheets("Sheet 2")

Selection.EntireRow.Select

With Selection
.Copy Destination:=sht2.Range("A2")
End With

« 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 04:47 PM.