jagrenet
Board Regular
- Joined
- Feb 23, 2022
- Messages
- 81
- Office Version
- 365
- 2013
- 2011
- 2010
- Platform
- Windows
Hello all,
I am looking to write a sub procedure that will count all rows then, search each row for the text "Event", in column B. When it finds "Event", I want it to look at column "AB" (for each Row in the Range) and if there is already a value in that cell, ignore it and move on. Conversely, if "AB" is empty for that Row, I want it to add "0.15" to the empty cell for me.
The worksheet varies in size each month so, it is dynamic. One month I might have 5 entries. The next month, there may be 372, etc.
I realize this is a fairly simple procedure but I have been running into problems trying to get it to work.
Thanks in advance,
Jeff
I am looking to write a sub procedure that will count all rows then, search each row for the text "Event", in column B. When it finds "Event", I want it to look at column "AB" (for each Row in the Range) and if there is already a value in that cell, ignore it and move on. Conversely, if "AB" is empty for that Row, I want it to add "0.15" to the empty cell for me.
The worksheet varies in size each month so, it is dynamic. One month I might have 5 entries. The next month, there may be 372, etc.
I realize this is a fairly simple procedure but I have been running into problems trying to get it to work.
Thanks in advance,
Jeff