Need help to modify code to include more than 1 Column

I was kindly assisted with the below code, but reslised afterwards that i need to ibtain the MAX value in a sheet that will be in Columns:
E, G, I & K.
There is some EMPTY cells between where the data values are placed in those columns.
The Value is ALWAYS a :
"st_1234" value IE. "st_xxxx. "st" & "Space" [# Characters] then 4 numerical digits.
I need to gain the MAX value Across ALL these Columns in Sheet8, and then ADD 1 to it, and place that value in a Textbox as the end of the code stipulates.

The other modification i need help with is:
I have 4 Textboxes on the userform that need reference to this MAX Value.
Textbox7 - Textbox10.
IF a MAX value is used in a PRECEDING Textbox, then the next Textbox IF requiring a value is to be The Precious Textbox Value + 1.

EG. If Textbox7.value = "1234" then Textbox8 needs to be "1235".
Hope i explained that clearly.

Please Login or Register  to view this content.

Regards


Corey....

Corey

How about

Please Login or Register  to view this content.

HTH

rylo