Select Visible Cells only copy & Paste

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I would like to create a macro that selects only cells containing
information from subtotalled worksheet,then copy visible cells only, and
paste them into another worksheet.

I have searched the existing Q&A's but can't find what I'm looking for.

Thanks in advance.
 
Kim, give something like this a try

Sub Macro1()
ActiveSheet.UsedRange.SpecialCells(xlCellTypeVisible).Copy _
Destination:=Sheet2.Range("A1")
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Range("C9").CurrentRegion.Columns(1). _
SpecialCells(xlVisible).entirerow.copy _

Worksheets(3).Range("A1").PasteSpecial xlValues
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Visible Cells and paste in another workbook visible cells only 5
Pasting to visible cells only? 1
Copy to Visible Cells only;Modify Code 11
How to copy and paste only visible cells from Excel using vbscript 0
I copied Visible Cells Only, but it pastes only the first cell 1
Copy only visible cells after applying "Subtotals" 2
Copy visible cells after filtered paste to first empty cell 1
Code to copy worksheet 5

Back
Top