Check if cell is empty then bolt cells in row

[Buskopan]

Hello,

need a macro that will check the column A4:A100 and if any blank cells there need to bold the font in that row

Thank you

 

[Buskopan]

Assuming the entries in column J are actual numbers (not text) and that they are not the result of formulas, maybe ..

Runtime error : (

File

 

[Peter_SSs]

Runtime error : (

File

I don't wish to download the file.

1. Please give the full error message.

2. When you get the error, click Debug and tell us which line caused the error (highlighted yellw)

3. I qualified my suggestion with an assumption "Assuming the entries in column J are actual numbers (not text)". Can you confirm that those numbers are actual numbers and not text values? For example, what does =ISNUMBER(J12) return?

 

[Buskopan]

I don't wish to download the file.

1. Please give the full error message.

2. When you get the error, click Debug and tell us which line caused the error (highlighted yellw)

3. I qualified my suggestion with an assumption "Assuming the entries in column J are actual numbers (not text)". Can you confirm that those numbers are actual numbers and not text values? For example, what does =ISNUMBER(J12) return?

1. Run-time error "1004"
2.

  For Each rArea In Range("H8", Range("H" & Rows.Count).End(xlUp)).SpecialCells(xlConstants, xlNumbers).Areas

3. Those are just numbers. (life boat numbers)

Thanks you!

 

[Peter_SSs]

1. Run-time error "1004"

I doubt that is the full error message that I asked for. Are you sure it doesn't also say "No cells were found"?

2.

  For Each rArea In Range("H8", Range("H" & Rows.Count).End(xlUp)).SpecialCells(xlConstants, xlNumbers).Areas

That would indicate there are no actual numbers in column H below row 8. Hence my comment above.

3. Those are just numbers.

You say they are numbers but your two answers above are indicating they are not numbers but text that looks like numbers. As I asked before, if you put the formula =ISNUMBER(J12) in a cell on the worksheet, what does that formula return?