Passing a private variable to another module

Andy -

Sorry, you lost me in your comments. I'm not sure what the "get/let" properties are nor do I know where to assign the value. The whole assigning variables and letting other procedures use these variables is somewhat new to me. Realistically, I would really like to declare "j" as a private variable and then pass the value to the function that needs it. I have attached a copy of the spreadsheet so you can see where each code is stored. HTH. Thanks again for your comments.

As I said, if you will copy the Public to the top of both the sheet and the Module, it will work. Or, Dim j in the module where it was not defined as Public.

While you have few rows and J as integer will work, it is generally a good practice to dim variables that reference row numbers as Long.

Hello maacmaac,

The attached file has the corrections. The row number "j' is now stored as a public variable "LineNumber" in the class module. Property Let assigns the value and Property Get returns the value.

Sincerely,
Leith Ross

That works now. Thanks for all the help and valuable comments from all.