Coping & pasting data in first blank cell in same worksheet
Closed
Jim
-
Dec 2, 2014 at 09:46 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 8, 2014 at 11:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 8, 2014 at 11:58 AM
Related:
- Coping & pasting data in first blank cell in same worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- An example of a cell is a blank cell ✓ - Programming Forum
- Mint mobile data not working ✓ - Network Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 8, 2014 at 11:58 AM
Dec 8, 2014 at 11:58 AM
Hi Jim,
Not sure which previous solution you are referring to but try this code:
Best regards,
Trowa
Not sure which previous solution you are referring to but try this code:
Sub RunMe()
For Each cell In Range("A13:A30")
If cell.Value = vbNullString Then
cell.Value = Range("M1")
Exit Sub
End If
Next cell
End Sub
Best regards,
Trowa
