synergy16
Active Member
- Joined
- Mar 17, 2016
- Messages
- 420
- Office Version
- 365
- Platform
- Windows
good morning all. I have a excel sheet, a build log. and the people that create tend to change the format so in order to get the text I need I first look for a ":" which triggers the start position of the text I need to capture. I then save that point to a variable which I then to use. my question is, how to I write the code to take all text after that variable. below is the code I have
Code:
colonLoc = InStr(Cells(adjLow + 2, 3), ":")
'*********ADJUST FOR NEW BUILD LOG STRUCTURE**************************
'6.3.---POWDER LOT NUMBER
pLnm = Right(Cells(adjLow + 2, 3).Value, colonLoc) 'adjusted
PLN.Caption = pLnm '