Inserting table column name into excel formula

[dpaton05]

I got a question answered and then I posted another question in the same thread. I forgot I needed to post new questions in new threads.

I get an error with trying to insert the following formula into a cell in vba.

.Range("M11").Formula = "=IF([@[Wait Time/Hrs]]<3,3,[@[Wait Time/Hrs]])"

The names are column headers

Thanks

 

[dpaton05]

I just hard coded in the cell reference and got it working.

 

[Peter_SSs]

I get an error with trying to insert the following formula into a cell in vba.

.Range("M11").Formula = "=IF([@[Wait Time/Hrs]]<3,3,[@[Wait Time/Hrs]])"

If M11 was in the table, then what you posted should be fine.

If M11 is not in the table, then you need to include the table name ..

.Range("M11").Formula = "=IF(Table1[@[Wait Time/Hrs]]<3,3,Table1[@[Wait Time/Hrs]])"

.. but note that a simpler formula could be

"=MAX(Table1[@[Wait Time/Hrs]],3)"

 

[dpaton05]

Thanks for that Peter, I will try it when I get back to work on Wednesday and let you know if there are any problems.