#1   Report Post  
Posted to microsoft.public.excel.misc
gillj
 
Posts: n/a
Default Macros in Excel

I am attempting to create a multi line macro in Excel, but when I run it, it
only prints the first line. I have tried creating the new line by both
pressing return and also by just moving the cursor down to the next line, but
when running the macro get the same result.

Any suggestions as to how I overcome this problem?
--
gillj
  #2   Report Post  
Posted to microsoft.public.excel.misc
kassie
 
Posts: n/a
Default Macros in Excel

You'll have to provide more detail here. We need to know what your macro
must achieve, and seeing your code will help us to help you

"gillj" wrote:

I am attempting to create a multi line macro in Excel, but when I run it, it
only prints the first line. I have tried creating the new line by both
pressing return and also by just moving the cursor down to the next line, but
when running the macro get the same result.

Any suggestions as to how I overcome this problem?
--
gillj

  #3   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default Macros in Excel

It would help if we could see the Macro. Could you post what you've got so
far, and give a bit more description on what you want it to do. When you say
"multi line" are you referring to lines within the Macro, rows in the
spreadsheet, or lines withing a cell?

"gillj" wrote:

I am attempting to create a multi line macro in Excel, but when I run it, it
only prints the first line. I have tried creating the new line by both
pressing return and also by just moving the cursor down to the next line, but
when running the macro get the same result.

Any suggestions as to how I overcome this problem?
--
gillj

  #4   Report Post  
Posted to microsoft.public.excel.misc
gillj
 
Posts: n/a
Default Macros in Excel


-- The macro is for use in producing invoices, the template for which is set
up in Excel. The majority of my invoices use exactly the same wording, i.e.

Collect defective item and transport to our workshop
Strip item
Clean parts
Etc.

What has been happening is that when I run the macro it only prints the
first line unless I position the cursor in exactly the same cell as the
starting point when creating the macro. It would not be possible for me to
do this.

Since my original posting, I have discovered that my problem is to do with
relative references. However, I have tried recording a macro with the
feature turned on, and then with it turned off, and the result is the same
each time.

A further problem which has just occurred is that when I press the €˜record
macro button, the stop recording toolbar which contains the relative
reference button no longer appears on the screen. Whats happened to it?
How do I get it back?

I would be grateful for any help on this as I have been struggling to
resolve it myself for some now..

gillj


"kassie" wrote:

You'll have to provide more detail here. We need to know what your macro
must achieve, and seeing your code will help us to help you

"gillj" wrote:

I am attempting to create a multi line macro in Excel, but when I run it, it
only prints the first line. I have tried creating the new line by both
pressing return and also by just moving the cursor down to the next line, but
when running the macro get the same result.

Any suggestions as to how I overcome this problem?
--
gillj

  #5   Report Post  
Posted to microsoft.public.excel.misc
kassie
 
Posts: n/a
Default Macros in Excel

Gillj,
As Elkar says, better to post your macro. Sounds like you need to create a
print range, or a named range to refer to, to get your macro to print what
you need, but really not enough info to go by. To get your stop recording
button back, click on Tools|Customize, select toolbars, and tick Stop
Recording. After that, when you want to stop a recording, NEVER use the
little X, instead, click on the square button

"Elkar" wrote:

It would help if we could see the Macro. Could you post what you've got so
far, and give a bit more description on what you want it to do. When you say
"multi line" are you referring to lines within the Macro, rows in the
spreadsheet, or lines withing a cell?

"gillj" wrote:

I am attempting to create a multi line macro in Excel, but when I run it, it
only prints the first line. I have tried creating the new line by both
pressing return and also by just moving the cursor down to the next line, but
when running the macro get the same result.

Any suggestions as to how I overcome this problem?
--
gillj

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 12:46 PM
How to remove excel macros still there after normal delete? James Excel Discussion (Misc queries) 1 April 20th 06 10:45 PM
I deleted all macros in Excel but still get dialog box VenitaC Excel Discussion (Misc queries) 2 September 19th 05 08:05 PM
Are macros created in Excel 2003 compatible with Excel 5.0/95? Hakmui Excel Discussion (Misc queries) 1 August 31st 05 02:33 AM
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 05:06 PM


All times are GMT +1. The time now is 04:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"