How do I create a macro of editing keystrokes?

S

scjanner

I'm copying information from the Internet to paste into Excel, but the
information doesn't come in the format I want. In some cases I want to take
the last 8 characters, delete them from the current cell and paste them into
the next column. In other cases I want to add dashes, parentheses or spaces
between so many characters. Using the record macro button only copies the
data, not the keystrokes I want to repeat (e.g. in VB ActiveCell.FormulaR1C1
= "whateverIwant"). How do I create a macro that copies the keystrokes?
 

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

List all tables, including document structure 0
Seeing Keystrokes for Macros 1
Hide screen movements when a macro is running 3
Word 2007 Assigning keystrokes to macros stored in an Add-in Templ 0
VBA word change keys 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
VBA Macro Training in Chennai 0
How do I create a macro that will select a range that can vary in 2

Top