Prev: Compare two columns with different codes
Next: Check the lasta character
From: Fred on 19 Apr 2010 02:19
I have selected data from a workbook that is automatically updated to another
workbook. It also copies the hiden cells, can I stop the hidden cells from
automatically be copied?
From: Jacob Skaria on 19 Apr 2010 02:22
Why dont you post the macro which you are currently using.

--
Jacob (MVP - Excel)


"Fred" wrote:

> I have selected data from a workbook that is automatically updated to another
> workbook. It also copies the hiden cells, can I stop the hidden cells from
> automatically be copied?
From: ozgrid.com on 19 Apr 2010 03:40
Sub CopyVisible()
Sheet1.UsedRange.SpecialCells(xlCellTypeVisible).Copy
'YOU WILL HAVE PROBLEMS WHEN PASTING
End Sub



--
Regards
Dave Hawley
www.ozgrid.com
"Fred" <Fred(a)discussions.microsoft.com> wrote in message
news:7E2E2FCD-8266-4B9E-A688-E48E99E5410B(a)microsoft.com...
>I have selected data from a workbook that is automatically updated to
>another
> workbook. It also copies the hiden cells, can I stop the hidden cells from
> automatically be copied?

 | 
Pages: 1
Prev: Compare two columns with different codes
Next: Check the lasta character