Finding cells with values

[aa2000]

Hello All

I am trying to write a macro which looks at the value in a cell, and if it is empty moves up one cell, and does so continuously until the active cell has a value, at which point it makes the active cell bold.

I tried using the .Find method but that code did not stop at the first cell with a value and just made every cell with a value bold.

Does anybody know how to do this?

Cheers

 

[Weaver]

say it's column "A" you're looking at

cells(rows.count,"A").end(xlup).font.bold = true

 

[aa2000]

I may be using this code wrong, but it only seems to make the first cell (from the bottom) in column A bold.
Is it possible to get it to search from any cell.

If c.Value = "KF" Then 
If c.Offset(0, -3).Value = "" Then Cells(Rows.Count, "A").End(xlUp).Font.Bold = True

Can I replace the "End" with c.Offset(0, -3) perhaps?

Cheers

 

[aa2000]

Is it possible to select c.Offset(0, -3) then use ActiveCell instead of .End as the starting point for the code?

Cheers

 

[Weaver]

Your initial description implied you only wanted to make the first non blank cell from the bottom bold.

Now you're saying you want the bold font to start from a row with specific content and to cover more than one cell.

Could you please restate your requirements?

 

[aa2000]

Sorry for the confusion, Weaver.

What I want to do is go through a column (D in my case) and if a certain value exists in Column d, then look at the cell in column A on the same row. If the cell is empty, then I want the macro to go up until it finds the first non blank cell and make it bold.

Is that clearer?

Cheers

 

[aa2000]

Actually Weaver, I was able to solve that problem by using to following code:

If c.Value = "Something" Then If c.Offset(0, -3).Value = "" Then c.Offset(0, -3).Select
    ActiveCell.End(xlUp).Font.Bold = True

Thank you for your help!

 

[Weaver]

Just so you know, you don't need to 'select'

If c.Value = "Something" Then If c.Offset(0, -3).Value = "" Then c.Offset(0, -3).End(xlUp).Font.Bold = True

should do the same job.

Won't make a lot of difference for one, but if you were doing many, it's much more efficient.