macro use with hlookup
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? |
macro use with hlookup
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? |
All times are GMT +1. The time now is 05:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com