Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pasting to a location
Hi I know this is basically a repeat of a past post of mine but I never got
it answered so I am trying again. I need to copy from a hidden worksheet & paste to a hidden diaog box, putting the picture in a specific location in the dialog box. My code isn't working, here is what I have... This is my current code. It doesn't work & hangs up where I try to place the image. If Sheets("Order Info").Cells(4, 6).Value = "2270" Then Sheets("Doors").Shapes("2270").Copy DialogSheets("Door").Paste < I get an error 438 here Selection.ShapeRange.IncrementLeft 144.75 Selection.ShapeRange.IncrementTop 34.5 DialogSheets("Door").Show Can anyone help me do this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting chart getting source data from new location | Charts and Charting in Excel | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
Tab location | Excel Discussion (Misc queries) | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) |