next line in macros

[LKowis]

I know there is an extremely simple solution to this, but
I cannot get my macros to run properly. How do
you "return the cartridge" in typewriter speak in
macros? I can get the first line of the macro to print
where I place my cursor, but then the following lines
move up to the top of the page where I recorded the
macro. What keystrokes must I do while recording the
macro to make them run in order?

 

[Bob Phillips]

Use the variable vbCrLf

debug.print myVar & vbCrLf & myVar2

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[LKowis]

That still doesn't make sense to me. I recorded these
before, and did not have to go into VBE, but I can't
remember how I did it. Does anyone know? Do I have to
press enter twice or something to skip to the next
line???? Please help, it's driving my nuts.

 

[Bob Phillips]

Try Alt-Enter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

Best you post a sample of the code you generated when recording so's we can
get a better idea of your needs.

Gord Dibben Excel MVP