ok thanks
On Monday, April 29, 2013 11:00:13 AM UTC+2, colmkav wrote:
> Hi, I am trying to execute this function to return the column number of a
> heading. However although the value is correctly 3 when it reaches the end
> of the function it becomes 0 when I set it to iFund2Col after leaving
> If (iFund2Col = GetHeadingColumnNumber(ws, "Fund")) < 0 Then
>
> ... it becomes 0 when I set it to iFund2Col after leaving the function ...
Nope. This is not C. That doesn't set iFund2Col, it tests for equality
with it.
You need to do the assignment in a separate statement.
On Monday, Apri
File attached
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
Share your file.
On Monday, 29 April 2013 14:30:13 UTC+5:30, colmkav wrote:
>
> Hi, I am trying to execute this function to return the column number of a
> heading. However although the value is correctly 3 when it reaches the end
> of the function it becomes 0 when I set it to iFund2Col after l
