Loop Problem
Dim cell As Range
... ... Sheet1.Range("B1").Value = Sheet1.Range("B1").Value + 1 'Range("AQ3").Value = Count <---- Good for first cell only For Each cell In Range("AQ3:AQ6")<--- Want to Loop to next empty cell If cell.Value < "" Then cell.Value = Count Next |
All times are GMT +1. The time now is 01:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com