|
|
#11
03-01-2017, 11:33 PM
|
|||
|
|||
There is only ever one active cell at a time in Excel and it is always on the active sheet so have to make sure sheet 1 is the active sheet to use this
Code:
' copy back to sheet 1
With Sheets("Sheet1")
.Activate '<~~ makes sure right sheet is active
.Rows(ActiveCell.Row).Insert Shift:=xlDown
Sheets("Sheet2").Range("A3:Z3").Copy .Range("A" & ActiveCell.Row)
End With
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode