How to indicate 'starting' value for LastRow = (...)Rows.Count,1) (...)

Hi Guys,

Please see below:

LastRow = ThisWorkbook.Sheets("Issue Log").Cells(Rows.Count, 1).End(xlUp).Row - 4
Me.tbTicketNo.Value = "[BHD#" & Format(LastRow, ["00000"]) & "]"

The code is working but I would like to start counting from specific value e.g. 10000 = [BHD#10000]. The case is that I' dont want to write [BHD#10000] into cell A10000 but have [BHD#10000] in A1.

I tried to solve this by adding value as shown below but as a/m I need to have this results starting from A1,A2,A3... not A10000,A100001 etc

Me.tbTicketNo.Value = "[BHD#" & Format(10000 + LastRow, ["00000"]) & "]"


Regards

Maybe Change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Cheers
Leo