Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am attempting to create a macro in Excel and am encountering problems.
The details are as follows: 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. I actually need to be able to commence the macro from any starting point. I am not very familiary with Excel, but 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 nowoccurred 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 these issues as I have been struggling to resolve them myself for some now. gillj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Editing a simple macro | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |