| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy hidden sheet data
I have a macro to copy and past data from one sheet to another. It works fine
when I have all the sheets open, but when I hide the source sheet (where my raw data is stored) macro gives me an error (400). Below is the code: Sheets("Temp").Select Range("A1") = "Gas" Sheets("Nlist").Select Range("A7").Select Selection.Copy Sheets("Temp").Select Range("A2").Select ActiveSheet.Paste I want my raw data sheet hidden ("Temp" sheet is always visible, and "Nlist" is the one I want to Hide), what can I do to keep my macro working when raw data sheet is hidden? Please advise.... Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy hidden sheet data
Sheets("Temp").Range("A1") = "Gas"
Sheets("Nlist").Range("A7").Copy Sheets("Temp").Range("A2") -- HTH... Jim Thomlinson "Atiq" wrote: I have a macro to copy and past data from one sheet to another. It works fine when I have all the sheets open, but when I hide the source sheet (where my raw data is stored) macro gives me an error (400). Below is the code: Sheets("Temp").Select Range("A1") = "Gas" Sheets("Nlist").Select Range("A7").Select Selection.Copy Sheets("Temp").Select Range("A2").Select ActiveSheet.Paste I want my raw data sheet hidden ("Temp" sheet is always visible, and "Nlist" is the one I want to Hide), what can I do to keep my macro working when raw data sheet is hidden? Please advise.... Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy hidden sheet data
It works! Thansk!
"Jim Thomlinson" wrote: Sheets("Temp").Range("A1") = "Gas" Sheets("Nlist").Range("A7").Copy Sheets("Temp").Range("A2") -- HTH... Jim Thomlinson "Atiq" wrote: I have a macro to copy and past data from one sheet to another. It works fine when I have all the sheets open, but when I hide the source sheet (where my raw data is stored) macro gives me an error (400). Below is the code: Sheets("Temp").Select Range("A1") = "Gas" Sheets("Nlist").Select Range("A7").Select Selection.Copy Sheets("Temp").Select Range("A2").Select ActiveSheet.Paste I want my raw data sheet hidden ("Temp" sheet is always visible, and "Nlist" is the one I want to Hide), what can I do to keep my macro working when raw data sheet is hidden? Please advise.... Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reading data from hidden sheet | Excel Discussion (Misc queries) | |||
| after creating a copy of a sheet, several rows missing (not hidden | Excel Discussion (Misc queries) | |||
| Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
| Excel: copy and paste only shown not hidden cells into new sheet | Excel Discussion (Misc queries) | |||
| How Can I copy a sheet that has hidden rows without copying the h. | Excel Worksheet Functions | |||
Linear Mode
