Avoid pasting over hidden rows

  • Thread starter Thread starter BMunny
  • Start date Start date
B

BMunny

Hi All

I have a quick question in regards to pasting data over a
range with hidden rows. Is it possible to paste data
over a range of cells and avoid pasting data in hidden
rows? Let's say sheet2 has data in range A1:B5 and row 2
is hidden. Let's say I copy range A1:B4 from Sheet1 and
paste on Sheet2 starting in cell A1. I would like the
data to paste over rows 1,3,4 and 5. (skip hidden row 2)

I'm pretty sure the answer is no but I thought I'd ask
anyways since there are some clever folks out there who
might find a way. (Without using VBA)

Thanks in advance.
 

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

Pasting over hidden columns 3
Possible Autofilter Bug (2003 and 2007) 5
Copy/Paste with Hidden Rows/Columns Excel 2007 3
how do i paste rows/columns avoiding hidden rows/columns 1
copy and paste range of cells excluding hidden data in excel 3
Copying data to the next blank row 0
Microsoft Excel 2007 - VBA To Sort Table And Copy To Another Sheet 2
drag data vertically over hidden cells.. ignore hidden cells 1

Back
Top