ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I use find in a macro in Excel (https://www.excelbanter.com/excel-worksheet-functions/27050-how-do-i-use-find-macro-excel.html)

Layna

How do I use find in a macro in Excel
 
I am trying to create a macro which searches a database and locates a project
file via its Unique project number- it then copies this informationj onto a
second sheet and the front sheet displays some of the information in a form
format. The macro wont work - I get to find when creating the macro and
everything just halts.

Nick

Hi Layna

Please post some of your code as it's impossible to tell what might be going
wrong.

Regards
Nick
"Layna" wrote in message
...
I am trying to create a macro which searches a database and locates a
project
file via its Unique project number- it then copies this informationj onto
a
second sheet and the front sheet displays some of the information in a
form
format. The macro wont work - I get to find when creating the macro and
everything just halts.




Don Guillett

Post your coding efforts for comments
Look in vba HELP index for FIND

--
Don Guillett
SalesAid Software

"Layna" wrote in message
...
I am trying to create a macro which searches a database and locates a

project
file via its Unique project number- it then copies this informationj onto

a
second sheet and the front sheet displays some of the information in a

form
format. The macro wont work - I get to find when creating the macro and
everything just halts.





All times are GMT +1. The time now is 07:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com