Seperate with space

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Could someone help me place a space between the
number and the letter S

Private Sub Increment_Click()
With Me.Range("K20")
..Value = .Value + 1
..NumberFormat = "00000""S"""

thanks
Pat
 
place a space before the S inside the quote

Sub test(
With Range("K20"
.Value = .Value +
.NumberFormat = "00000"" S""
End Wit
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number and text format 1
Multiple Fxns in single sheet module 0
Date Stamp 4
Toggle Calculation Status 5
Snag in invoice generator. How to change the "series" 5
How to Select A Cell in VBA with a Variable Row Number? 3
Unexpected issue with VBA code received 2
Worksheet_Change event to unhide columns based on value in range 7

Back
Top