I have a macro that enters a new row and then carries out
a series of instructions based upon this inserted row, for
example entering 'filled down' calculations in the new row
and other similar processes.
I would also like the macro to amend a HLOOKUP function
(as when the row is inserted the array size increases by
one, as does the required row).
For example, before the macro is run the function looks
like this:

=HLOOKUP('Project Summary'!B1,'Associates Hours (actuals)'!
S5:AD76,72,TRUE)*30

but then after i need the function to look like this:
=HLOOKUP('Project Summary'!B1,'Associates Hours (actuals)'!
S5:AD76,72,TRUE)*30

However i am not sure how to get round this problem. Any
ideas?

Hi
see Excel.misc

--
Regards
Frank Kabel
Frankfurt, Germany


kate wrote:
I have a macro that enters a new row and then carries out
a series of instructions based upon this inserted row, for
example entering 'filled down' calculations in the new row
and other similar processes.
I would also like the macro to amend a HLOOKUP function
(as when the row is inserted the array size increases by
one, as does the required row).
For example, before the macro is run the function looks
like this:

=HLOOKUP('Project Summary'!B1,'Associates Hours (actuals)'!
S5:AD76,72,TRUE)*30

but then after i need the function to look like this:
=HLOOKUP('Project Summary'!B1,'Associates Hours (actuals)'!
S5:AD76,72,TRUE)*30

However i am not sure how to get round this problem. Any
ideas?