Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
I have recently set up three Excel spreadsheets for formatting data imported
from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
Not sure, but I would simplify your code a little.
Rows("1:1").Insert Shift:=xlDown Range("A1").Value = "Supplier" Range("B1").Value = "SageRef" Range("C1").Value = "Item" Range("D1").Select HTH, Paul "Gillian" wrote in message ... I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
Thanks,
I'll try that. Incidentally, I didn't write the actual code - that's what Excel put in for me when I did a simple 'Record Macro' and it recorded my keystrokes. "PCLIVE" wrote: Not sure, but I would simplify your code a little. Rows("1:1").Insert Shift:=xlDown Range("A1").Value = "Supplier" Range("B1").Value = "SageRef" Range("C1").Value = "Item" Range("D1").Select HTH, Paul "Gillian" wrote in message ... I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
when you step through it does it show B1,C1 etc being selected?
it sounds as though his computer may have a problem with "select" do other macros work OK? "Gillian" wrote: I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
The step through process shows that it refuses to budge out of cell A1.
But yes, other macros work perfectly well and they have a very similar set of instructions except for the first 'insert row' bit. Also, exactly the same errors happen on another pc in another office as well! Could it be an MS update issue? Gillian "bj" wrote: when you step through it does it show B1,C1 etc being selected? it sounds as though his computer may have a problem with "select" do other macros work OK? "Gillian" wrote: I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
go to the computer which has the problem
record a macro for the first couple of steps and see what it says and if it works. if it works copy the selection and insert lines and paste into the old macro. See if it works now? "Gillian" wrote: The step through process shows that it refuses to budge out of cell A1. But yes, other macros work perfectly well and they have a very similar set of instructions except for the first 'insert row' bit. Also, exactly the same errors happen on another pc in another office as well! Could it be an MS update issue? Gillian "bj" wrote: when you step through it does it show B1,C1 etc being selected? it sounds as though his computer may have a problem with "select" do other macros work OK? "Gillian" wrote: I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
I have finally tracked down the problem, although I still don't understand
why it should happen on one pc but not on another. I was at the computer where the error was happening and trying once more to step through the macro before trying your suggestion. At first I thought it was working as actually went through the first 20 or so commands. It fell over at the section of macro shown below. When I stopped the debugger and tried to run it again, that's when it refused to move out of cell A1 as initially reported in this post and Excel collapsed to the extent that I had to use the Task Manager to shut it down. The guilty part of the macro is: Columns("Y:Y").Select Selection.Cut Range("U1").Select ActiveSheet.Paste It failed at the paste option, with a run time error. I just changed the macro to: Columns("Y:Y").Select Selection.Copy Range("U1").Select ActiveSheet.Paste And everything works fine. Why? I don't know. But at least it works now. Thanks for your suggestions. "bj" wrote: go to the computer which has the problem record a macro for the first couple of steps and see what it says and if it works. if it works copy the selection and insert lines and paste into the old macro. See if it works now? "Gillian" wrote: The step through process shows that it refuses to budge out of cell A1. But yes, other macros work perfectly well and they have a very similar set of instructions except for the first 'insert row' bit. Also, exactly the same errors happen on another pc in another office as well! Could it be an MS update issue? Gillian "bj" wrote: when you step through it does it show B1,C1 etc being selected? it sounds as though his computer may have a problem with "select" do other macros work OK? "Gillian" wrote: I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
I have 'solved' this problem... see the post submitted today in response to bj.
Regards, Gillian "PCLIVE" wrote: Not sure, but I would simplify your code a little. Rows("1:1").Insert Shift:=xlDown Range("A1").Value = "Supplier" Range("B1").Value = "SageRef" Range("C1").Value = "Item" Range("D1").Select HTH, Paul "Gillian" wrote in message ... I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
If you want column Y to be removed you might want to add
Columns("Y:Y").Select Application.CutCopyMode = False Selection.Clear it is an oddity. I could not make your code fail on my computer 2003 XP "Gillian" wrote: I have finally tracked down the problem, although I still don't understand why it should happen on one pc but not on another. I was at the computer where the error was happening and trying once more to step through the macro before trying your suggestion. At first I thought it was working as actually went through the first 20 or so commands. It fell over at the section of macro shown below. When I stopped the debugger and tried to run it again, that's when it refused to move out of cell A1 as initially reported in this post and Excel collapsed to the extent that I had to use the Task Manager to shut it down. The guilty part of the macro is: Columns("Y:Y").Select Selection.Cut Range("U1").Select ActiveSheet.Paste It failed at the paste option, with a run time error. I just changed the macro to: Columns("Y:Y").Select Selection.Copy Range("U1").Select ActiveSheet.Paste And everything works fine. Why? I don't know. But at least it works now. Thanks for your suggestions. "bj" wrote: go to the computer which has the problem record a macro for the first couple of steps and see what it says and if it works. if it works copy the selection and insert lines and paste into the old macro. See if it works now? "Gillian" wrote: The step through process shows that it refuses to budge out of cell A1. But yes, other macros work perfectly well and they have a very similar set of instructions except for the first 'insert row' bit. Also, exactly the same errors happen on another pc in another office as well! Could it be an MS update issue? Gillian "bj" wrote: when you step through it does it show B1,C1 etc being selected? it sounds as though his computer may have a problem with "select" do other macros work OK? "Gillian" wrote: I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
another thing to check, too (even though you've solved it)......
on YOUR computer, open vb editor & look at Tools, Options, and choose the General tab. to the (R) you'll see an "Error Trapping" frame. write down which option your computer has selected. go check the other computers. if they're not set the same, that may be why it errored out on theirs, but not on yours. this is an option that's individual to each computer and is not carried along by macros. hth susan On Jun 14, 8:30 am, bj wrote: If you want column Y to be removed you might want to add Columns("Y:Y").Select Application.CutCopyMode = False Selection.Clear it is an oddity. I could not make your code fail on my computer 2003 XP "Gillian" wrote: I have finally tracked down the problem, although I still don't understand why it should happen on one pc but not on another. I was at the computer where the error was happening and trying once more to step through the macro before trying your suggestion. At first I thought it was working as actually went through the first 20 or so commands. It fell over at the section of macro shown below. When I stopped the debugger and tried to run it again, that's when it refused to move out of cell A1 as initially reported in this post and Excel collapsed to the extent that I had to use the Task Manager to shut it down. The guilty part of the macro is: Columns("Y:Y").Select Selection.Cut Range("U1").Select ActiveSheet.Paste It failed at the paste option, with a run time error. I just changed the macro to: Columns("Y:Y").Select Selection.Copy Range("U1").Select ActiveSheet.Paste And everything works fine. Why? I don't know. But at least it works now. Thanks for your suggestions. "bj" wrote: go to the computer which has the problem record a macro for the first couple of steps and see what it says and if it works. if it works copy the selection and insert lines and paste into the old macro. See if it works now? "Gillian" wrote: The step through process shows that it refuses to budge out of cell A1. But yes, other macros work perfectly well and they have a very similar set of instructions except for the first 'insert row' bit. Also, exactly the same errors happen on another pc in another office as well! Could it be an MS update issue? Gillian "bj" wrote: when you step through it does it show B1,C1 etc being selected? it sounds as though his computer may have a problem with "select" do other macros work OK? "Gillian" wrote: I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received.- Hide quoted text - - Show quoted text - |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
what version of EXCEL dop you Have? 2003 Xl does not appear to have this option
"Susan" wrote: another thing to check, too (even though you've solved it)...... on YOUR computer, open vb editor & look at Tools, Options, and choose the General tab. to the (R) you'll see an "Error Trapping" frame. write down which option your computer has selected. go check the other computers. if they're not set the same, that may be why it errored out on theirs, but not on yours. this is an option that's individual to each computer and is not carried along by macros. hth susan On Jun 14, 8:30 am, bj wrote: If you want column Y to be removed you might want to add Columns("Y:Y").Select Application.CutCopyMode = False Selection.Clear it is an oddity. I could not make your code fail on my computer 2003 XP "Gillian" wrote: I have finally tracked down the problem, although I still don't understand why it should happen on one pc but not on another. I was at the computer where the error was happening and trying once more to step through the macro before trying your suggestion. At first I thought it was working as actually went through the first 20 or so commands. It fell over at the section of macro shown below. When I stopped the debugger and tried to run it again, that's when it refused to move out of cell A1 as initially reported in this post and Excel collapsed to the extent that I had to use the Task Manager to shut it down. The guilty part of the macro is: Columns("Y:Y").Select Selection.Cut Range("U1").Select ActiveSheet.Paste It failed at the paste option, with a run time error. I just changed the macro to: Columns("Y:Y").Select Selection.Copy Range("U1").Select ActiveSheet.Paste And everything works fine. Why? I don't know. But at least it works now. Thanks for your suggestions. "bj" wrote: go to the computer which has the problem record a macro for the first couple of steps and see what it says and if it works. if it works copy the selection and insert lines and paste into the old macro. See if it works now? "Gillian" wrote: The step through process shows that it refuses to budge out of cell A1. But yes, other macros work perfectly well and they have a very similar set of instructions except for the first 'insert row' bit. Also, exactly the same errors happen on another pc in another office as well! Could it be an MS update issue? Gillian "bj" wrote: when you step through it does it show B1,C1 etc being selected? it sounds as though his computer may have a problem with "select" do other macros work OK? "Gillian" wrote: I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received.- Hide quoted text - - Show quoted text - |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro will work on one computer but not on another
Yes it does, press alt + F11, then do toolsoptions, select the general tab
-- Regards, Peo Sjoblom "bj" wrote in message ... what version of EXCEL dop you Have? 2003 Xl does not appear to have this option "Susan" wrote: another thing to check, too (even though you've solved it)...... on YOUR computer, open vb editor & look at Tools, Options, and choose the General tab. to the (R) you'll see an "Error Trapping" frame. write down which option your computer has selected. go check the other computers. if they're not set the same, that may be why it errored out on theirs, but not on yours. this is an option that's individual to each computer and is not carried along by macros. hth susan On Jun 14, 8:30 am, bj wrote: If you want column Y to be removed you might want to add Columns("Y:Y").Select Application.CutCopyMode = False Selection.Clear it is an oddity. I could not make your code fail on my computer 2003 XP "Gillian" wrote: I have finally tracked down the problem, although I still don't understand why it should happen on one pc but not on another. I was at the computer where the error was happening and trying once more to step through the macro before trying your suggestion. At first I thought it was working as actually went through the first 20 or so commands. It fell over at the section of macro shown below. When I stopped the debugger and tried to run it again, that's when it refused to move out of cell A1 as initially reported in this post and Excel collapsed to the extent that I had to use the Task Manager to shut it down. The guilty part of the macro is: Columns("Y:Y").Select Selection.Cut Range("U1").Select ActiveSheet.Paste It failed at the paste option, with a run time error. I just changed the macro to: Columns("Y:Y").Select Selection.Copy Range("U1").Select ActiveSheet.Paste And everything works fine. Why? I don't know. But at least it works now. Thanks for your suggestions. "bj" wrote: go to the computer which has the problem record a macro for the first couple of steps and see what it says and if it works. if it works copy the selection and insert lines and paste into the old macro. See if it works now? "Gillian" wrote: The step through process shows that it refuses to budge out of cell A1. But yes, other macros work perfectly well and they have a very similar set of instructions except for the first 'insert row' bit. Also, exactly the same errors happen on another pc in another office as well! Could it be an MS update issue? Gillian "bj" wrote: when you step through it does it show B1,C1 etc being selected? it sounds as though his computer may have a problem with "select" do other macros work OK? "Gillian" wrote: I have recently set up three Excel spreadsheets for formatting data imported from a text file generated in a DOS program. Once the data is pasted into the master spreadsheet it is renamed with a date and a set of two or three macros that manipulate the data, inserting/hiding columns, adding up, subtotals, formatting, etc. The files are held on a shared drive on our network. On my computer (using Excel 2000 on WinXP) each of the four files and their macros work perfectly. On my colleague's computer (using the same version of Excel and XP) only two of the macros will work. On the other two we get a Debug message. When we look at the macro using F8 to step through we can see that the only functions to work are those where text is typed in. For example, the first few rows of the first macro are this: Range("A1").Select Selection.EntireRow.Insert ActiveCell.FormulaR1C1 = "Supplier" Range("B1").Select ActiveCell.FormulaR1C1 = "SageRef" Range("C1").Select ActiveCell.FormulaR1C1 = "Item" Range("D1").Select What happens, though, is: No row is inserted All the above text is written into A1 instead of moving to B1, C1, D1, and so on. So of course the macro soon fails altogether. I am completely stumped! Any suggestions very gratefully received.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I call My Computer through an Excel macro? | Excel Discussion (Misc queries) | |||
Cell Referal between tabs fails to work properly on home computer | Excel Worksheet Functions | |||
hyperlink that are relavant to a work book not a computer | Excel Worksheet Functions | |||
Transfer Macro code to another computer | Excel Discussion (Misc queries) | |||
How do i set up my desktop computer to work from my laptop | New Users to Excel |