How to write loop to check for empty cells

**JaydenK** · 07-19-2013, 03:55 PM

Hello all,

I'm new to VBA and was wondering how would I go about to write a loop to check for empty cells? For example, I have a column named Cycle Time and every file has a different number of cycles. I want to apply a simple formula [###/(3600/16)] if and only if there is a corresponding value in the cycle time column. example.jpg Any help would be appreciated!

Thanks,

J

**Solus Rankin** · 07-19-2013, 03:58 PM

What would you like to do if an empty cell is found?

**JaydenK** · 07-19-2013, 04:00 PM

Sorry, forgot to mention that if an empty cell is found, it is finished and doesn't do anything else.

**Solus Rankin** · 07-19-2013, 04:03 PM

Oh I think I understand. You would like to copy the formula in every cell in column Y that has data in column X?

**Solus Rankin** · 07-19-2013, 04:08 PM

Try:

Please Login or Register  to view this content.

You'll have the change A to the column you want to check for a value and B to the column you'd like to place the formula. Also the formula you'd like to enter can be any formula. Just change the formula between the "" to the formula you'd like.

**JaydenK** · 07-19-2013, 04:39 PM

Yes, that's pretty much what I'm looking for. For the formula part, if I want to have it to take the value of A, would it be something like
Range("B" & l).Formula = "=A/(3600/16)"?

Thank you so much for the help so far.

**Solus Rankin** · 07-19-2013, 04:57 PM

The value of A the column? A specific row in that column?

**JaydenK** · 07-22-2013, 08:44 AM

Nevermind, I got it. Thank you so much for the help!

**Solus Rankin** · 07-22-2013, 09:17 AM

I'm glad you got it figured out. If you are happy with the solution please mark the thread as [SOLVED].

How to write loop to check for empty cells

LinkBack

Thread Tools

Rate This Thread

Display

How to write loop to check for empty cells

Re: How to write loop to check for empty cells

Re: How to write loop to check for empty cells

Re: How to write loop to check for empty cells

Re: How to write loop to check for empty cells

Re: How to write loop to check for empty cells

Re: How to write loop to check for empty cells

Re: How to write loop to check for empty cells

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Check for empty cells on exit

Need Help to write Macro which should check coloumn cells should not contain '-app'

check for non-empty cells outside of a certain range

check for non-empty cells outside of a certain range

[SOLVED] Empty cells in For Loop

Bookmarks

Bookmarks

Posting Permissions