Understanding Cell Object

[AEngineer]

In "Excel VBA Power Programming 2016" Chapter 7 there is a function to determine where the format of a cell is Bold

Function ISBOLD(cell) As Boolean
' Returns TRUE if cell is bold
ISBOLD = cell.Range("A1").Font.Bold
End Function

It works when used in a spreadsheet and "cell" is an address such as "A2"
When I put it in sub I could not get it to work. If I changed "cell" to "range" then it worked fine.

My suspicion is that I'm not understanding what "cell" means. Is it an object like Range? If so, shouldn't cell.address do the same thing as ActiveCell.Range.Address?

I'd appreciate guidance.

 

[HankJ]

In "Excel VBA Power Programming 2016" Chapter 7 there is a function to determine where the format of a cell is Bold

Function ISBOLD(cell) As Boolean
' Returns TRUE if cell is bold
ISBOLD = cell.Range("A1").Font.Bold
End Function

It works when used in a spreadsheet and "cell" is an address such as "A2"
When I put it in sub I could not get it to work. If I changed "cell" to "range" then it worked fine.

My suspicion is that I'm not understanding what "cell" means. Is it an object like Range? If so, shouldn't cell.address do the same thing as ActiveCell.Range.Address?

I'd appreciate guidance.

Going out on a limb here as this is my first reply to a query.

I think / hope that it might be that you need to define (Dim) Cell as a range and then Set the range to the cell you want to process.

but I could be wrong, so will be interested to read any follow ups.

Hj

 

[AEngineer]

I think I tried that without any luck. I tried many things that didn't work.

 

[dmt32]

Hi,
When passing arguments like any other variable declaration in code, it is always good practice to declare their data type.

Cell I would have thought would be a Range Object & argument expressed as follows

Function ISBOLD(ByVal cell As Range) As Boolean
' Returns TRUE if cell is bold
ISBOLD = cell.Font.Bold
End Function

and as an example, call it like this

Sub abc()
 MsgBox ISBOLD(Cells(1, 1))
End Sub

Dave

 

[AEngineer]

Thanks. I feared that cell was an object that I wasn't understanding. I guess not.