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

what I think would work is if I could define the following destination line of code to read

.Copy Destination:=sht1.Range("A2") but with ("A2") modified to reflect col A of the active row sheet one that was inserted
Reply With Quote