Thread
: [Solved]
deleting blanks and commas
View Single Post
03-01-2017, 09:36 PM
FUGMAN
Windows 10
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
FUGMAN
View Public Profile
Find all posts by FUGMAN