Keeping a lastrow Variable Across Modules

Hello Everyone,

I looked around the internets and couldn't find much of an answer for this - I'm trying to make it so that a lastrow I defined in one module will still be defined in another macro.

My background for this - my macro is too large for one module, therefore, I split it in two. However, the new module uses defined variables (multiple lastrow definitions) from the original module.

So, is there a way to make it so when I originally define a lastrow in one module, other modules will recognize it?

Thanks in advance!

One way:

Sub Main_Macro()

Call Module_1
Call Module_2

End Sub

Public lastrow As Long
Sub Module_1()

lastrow = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row

End Sub

Sub Module_2()

MsgBox (lastrow)

End Sub

stnkynts (i'm glad the old man let you off the back of the truck, btw) and richard,

I apologize that I can't copy the macro as an example (work restrictions) but is there a way to do this within the macro? The reason I'm not just redefining the lastrow in module2 is because multiple changes are made to the worksheet after it is defined (rows are added, some with data and some blank).

Thanks again!

That is what declaring it as public is doing. Here is some further clarification/ working proof of the same thing I showed earlier.

Option Explicit
Public lastrow As Long
Sub Main_Macro()

Call Module_1
Call Module_2

End Sub

Sub Module_1()

lastrow = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row
'lastrow starts at 4
Debug.Print lastrow

End Sub

Sub Module_2()
Dim i As Integer

For i = 1 To 3
    Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Value = "test"
Next i

MsgBox (lastrow) 'returns 4
Debug.Print Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row 'returns 7

End Sub

stnkynts - I think I have it right now, but do I have to make every lastrow that I have set a new module with this? Is there any way to make it so the rest of them don't need to be set the same way?

Thanks!

I'm not quite sure what you mean.

Any variable that you want accessable across modules needs to be publicaly declared. If the variable value needs to be updated just update the value within the code at the point which you need.

Okay, here's an example of what I'm talking about - I have about 10 other lastrow variables out there. Let's say one of them is only in one module, will I still need to make that public and enter the the code you provided above?

Thanks