Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cutting cell with object
I have a number of macros which run just fine on the computer that I
generated them on. This computer has Excel version 2002 SP3. The code fails on a simple operation when I run the code on another machine with Excel version 2000. The section of code is: Range("E3").Select Selection.Cut Picture_Column = NumberOfCategories + 6 Sheets("All Concepts").Cells(3, Picture_Column).Select ActiveSheet.Paste Range("E3") contains a button and scroll bar that I want to move to another location. Is the issue as simple as the difference in Excel versions or is there something subtle I am missing. Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cutting cell with object
Try it like this:
Picture_Column = NumberofCategories + 6 Range("E3").Cut Sheets("All Concepts") _ .Cells(3, Picture_Column) If you still have problems, you may have a missing reference in your workbook. After the error, go into the VBE with your project as the activeproject (selected in the project window) and go to Tools=References (may have to hit reset first) and see if one of your references is marked as MISSING. If so, you need to clear this up. -- Regards, Tom Ogilvy "ZipCurs" wrote: I have a number of macros which run just fine on the computer that I generated them on. This computer has Excel version 2002 SP3. The code fails on a simple operation when I run the code on another machine with Excel version 2000. The section of code is: Range("E3").Select Selection.Cut Picture_Column = NumberOfCategories + 6 Sheets("All Concepts").Cells(3, Picture_Column).Select ActiveSheet.Paste Range("E3") contains a button and scroll bar that I want to move to another location. Is the issue as simple as the difference in Excel versions or is there something subtle I am missing. Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutting text from one cell to paste in another? | Excel Worksheet Functions | |||
Excel Cell Text Cutting Off | Excel Discussion (Misc queries) | |||
cutting characters from a cell | Excel Worksheet Functions | |||
Help Please Cutting and pasting based on cell value | Excel Programming | |||
Cutting Data from cells changes Cell Formatting | Excel Programming |