Copy cells in excel if cell above is null
Closed
Tara
-
Mar 14, 2012 at 09:42 PM
aquarelle Posts 7119 Registration date Saturday April 7, 2007 Status Moderator Last seen October 18, 2022 - Mar 15, 2012 at 05:32 AM
aquarelle Posts 7119 Registration date Saturday April 7, 2007 Status Moderator Last seen October 18, 2022 - Mar 15, 2012 at 05:32 AM
Related:
- Copy cells in excel if cell above is null
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel if cell is date ✓ - Office Software Forum
- Excel if cell color is red then - Guide
- Count if cell contains number - Excel Forum
2 replies
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Mar 15, 2012 at 02:19 AM
Mar 15, 2012 at 02:19 AM
why not just sort column A
aquarelle
Posts
7119
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
October 18, 2022
491
Mar 15, 2012 at 05:32 AM
Mar 15, 2012 at 05:32 AM
Hi,
Try this macro :
Best regards
Try this macro :
Sub CompleteEmptyCell() x = Range("A65536").End(xlUp).Row For y = 1 To x If Range("A" & y) = "" Then Range("A" & y) = Range("A" & y + 1) Next End Sub
Best regards