Hi,
Is it possible to add a piece of code to the formula below to limit the answer eg
Sheets("data").Range("BN" & x + 1).Select
xCustomerShort = ActiveCell.Value
Returns eg:
ActiveCell.Value = "Stephen"
Required :
ActiveCell.Value Limit to 4 = "Step"
thanks
Steve
Is it possible to add a piece of code to the formula below to limit the answer eg
Sheets("data").Range("BN" & x + 1).Select
xCustomerShort = ActiveCell.Value
Returns eg:
ActiveCell.Value = "Stephen"
Required :
ActiveCell.Value Limit to 4 = "Step"
thanks
Steve