Substring to replace string

F

Frank Kabel

Hi
try something like

with activesheet.range("A1")
.value = left(.value,5)
end with
 

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

Substring to replace string 3
Hide a Sheet 3
Delete an autostart Sub with code 6
After Filter - Move to first cell 4
Excel Macro 1
NEED TO REPEAT ROWS AT THE BOTTOM OF EXCEL SPREAD SHEET 5
Embedding Command Buttons in a Text box or List box 1
Make a Excel Chat through Visual Basic 6.0 6

Top