Copy xlCellTypeVisible if blank
Closed
Tjones4852
Posts
11
Registration date
Monday May 10, 2010
Status
Member
Last seen
December 9, 2011
-
Dec 6, 2010 at 02:56 PM
Tjones4852 Posts 11 Registration date Monday May 10, 2010 Status Member Last seen December 9, 2011 - Dec 7, 2010 at 06:24 PM
Tjones4852 Posts 11 Registration date Monday May 10, 2010 Status Member Last seen December 9, 2011 - Dec 7, 2010 at 06:24 PM
Related:
- Copy xlCellTypeVisible if blank
- Blank white square ✓ - Monitor Forum
- Blank facebook page ✓ - Facebook Forum
- If cell is zero then blank - Excel Forum
- Messenger is blank white screen pc - Facebook Forum
- Website loads but is blank ✓ - Network Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 7, 2010 at 04:23 AM
Dec 7, 2010 at 04:23 AM
I have not seen the data or the full macro .
my assumption is the row 1 and 2 are column headings and data starts from third row.
however my suggestion is
after the line
introduce aline
and then come the rest of the macro
check whether it help-s
the new lines gives the first cells in the first column of the filtered data.
my assumption is the row 1 and 2 are column headings and data starts from third row.
however my suggestion is
after the line
Range(("D3"), Range("AF65536").End(xlUp)).Select
introduce aline
If Selection.SpecialCells(xlCellTypeVisible).Cells(1, 1) = "" Then Exit Sub
and then come the rest of the macro
check whether it help-s
the new lines gives the first cells in the first column of the filtered data.
Dec 7, 2010 at 06:24 PM