| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste row into Sheet2 in next row
It is helpful to those responding to questions if certain information is always provided along with the question...
1. Excel version 2. Computer operating system 3. Complete error message 4. The line at which the error occurs. 5. What is the code supposed to do. 6. What you have tried in order to fix the problem. '----- Replace this line at the bottom of the code... MsgBox "An error occurred." With this line... MsgBox Err.Number & " - " & Err.Description Post back. -- Jim Cone Portland, Oregon USA ( http://tinyurl.com/PrimitiveSoftware ) "kaydee" wrote in message ... Hi All, I found code and tried to change it to make it fit me worksheet. I am using a inputbox to get a date range for report selection. The following code highlights and copies the first matchof my criteria set then I get the Err_Execute message in the sheet that I am copying to. Can someone tell me what is wrong with my code? Thanks Kim 'snip |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy from sheet1 then paste special transpose to sheet2,3,4 | Excel Discussion (Misc queries) | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| macro to print sheet2 without open sheet2 | Excel Discussion (Misc queries) | |||
| Macro to Copy data from a list in sheet1 and paste into sheet2 | Excel Discussion (Misc queries) | |||
| how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
![Jim Cone[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
