If is empty auto fill condition- loop through for first blank row/cell

Please Login or Register  to view this content.

Hi Steven

Can't say what is wrong with this code at the first glance as the other works according to you. Could it be a spelling mistake in the string or an extra space in worksheet cells?

By the way if this code is supposed to work on the same file as I made a macro for and if you only wish to set font bold that could be included in my previous code i.e:

Please Login or Register  to view this content.

Perhaps you could upload a small file sample after removing sensitive information showing how the data look like and how you would like it to look after the change.

Alf

Please Login or Register  to view this content.

Hi Steven

I did a bit of testing with your macro an I don't have any problem with filling the empty cells with the proper values but on the other hand I tested only a range with 16 values with three empty cells in that range.

What i did have problem with was the "Font.Bold" setting that I could not get to work so I had to change code a bit. As I use "Option Explicit" when writing macros I had to declare all variables.

Please Login or Register  to view this content.

Alf

Please Login or Register  to view this content.

This is rather strange. I've no problem with your code as far as I understand what you wish to do. I've uploaded a small file created in Excel 2010.

Since your macro specifies three cases only the three first empty cells are filled with text set to bold. The forth empty cell is not modified by macro.

Test and see if this macro works in your excel environment.

Alf