Auto Numbering script Problem

[AHawkins_Bjorksten]

I am working on a script that checks for data in column B. It places an incremental number in column A until it notices that there is no more data. I thought I had this working Wednesday but today, for some reason isn't doing anything when I try to execute the macro. BOM is the name of the sheet. This is semi-related to another post that I made :
http://www.excelforum.com/excel-prog...ror-400-a.html

They are both part of a template that I'm using to automate my Bill of Materials sheet. If it would help, I could attach the whole template.

Please Login or Register  to view this content.

[Leith Ross]

Hello AHawkins_Bjorksten,

A potential problem with using the Find method is not setting the named arguments that are remembered by the system. Here is a list of those named arguments: LookIn, LookAt, SearchOrder, and MatchByte.

I have added the named arguments to your code. I have also provided another method. Since you know the starting row and column where the data will be, you can locate the last entry in just that column. This is a method I use often because of the programming felxibity.

Please Login or Register  to view this content.

Alternate Method

Please Login or Register  to view this content.