Thread: [Solved] deleting blanks and commas
View Single Post
 
Old 03-01-2017, 09:36 PM
FUGMAN FUGMAN is offline Windows 10 Office 2016
Banned
 
Join Date: Feb 2017
Posts: 55
FUGMAN is on a distinguished road
Default

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
Reply With Quote