using fill handle with hidden rows
 

When I use the fill handle to copy something down to a new row, the hidden
rows in between are also filled in. Is there any way I can stop this so that
it only copies to the rows that are showing? Thank you.

using fill handle with hidden rows
 

One way to copy a8 to visible in a9:a20

Sub CopyToVisibleCellsOnly()
For Each c In Range("a9:a20")
If c.Rows.Hidden = False Then Range("a8").Copy c
Next
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Shazzer" wrote in message
...
When I use the fill handle to copy something down to a new row, the hidden
rows in between are also filled in. Is there any way I can stop this so
that
it only copies to the rows that are showing? Thank you.

using fill handle with hidden rows
 

Thank you Don. Tbh it was more a setting I was looking for because I keep
accidentally overwriting the hidden rows. Thanks

"Don Guillett" wrote:


One way to copy a8 to visible in a9:a20

Sub CopyToVisibleCellsOnly()
For Each c In Range("a9:a20")
If c.Rows.Hidden = False Then Range("a8").Copy c
Next
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Shazzer" wrote in message
...
When I use the fill handle to copy something down to a new row, the hidden
rows in between are also filled in. Is there any way I can stop this so
that
it only copies to the rows that are showing? Thank you.