I have a macro which modifies the user's input which will be in the form of =4*3.6 or =(4*3.6)+(6*4.8)or similar. The macro then converts that to a string 4 @ 3.6 three cells to the left on the row below. Before the macro can continue the active cell must be in column F. I can use a Msg box with OKCancel to inform but if the user is off by one column the advanced filter output doesn't work

Okay, and the problem is...?

Ok, I understand Razor's comment :-)

Koro, if you're able to make a macro then you're halfway. Select the menu [Extra][Macro][Macros]. Edit your macro and put some code in it like:

Dim iCol as integer

iCol=ActiveCell.Column
if iCol<>5 then 'this is the 6th column
exit sub
end if

I'm not sure at this moment if columns are counted from zero otherwise check the value at runtime when hovering your mouse over the 'iCol' variable.

You could use something similar for row checking.

Good luck

Many thanks i've been searching for days, many sources for finding particular cells, ranges, and rows. Thanks again