Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Enter' key is pasting...
We use a tool called Macro Express in conjunction with an Excel workbook, which copies specific Excel data to input into another application. I have been enhancing the user workbook using some formulas/validation/VBA code/macros, and now I am having an issue with the Enter function. Once all work has been completed in the workbook, a macro is run to copy the worksheet, paste the values, remove validation & formats everything as text (this is done with an excel macro tied to a button the user clicks..i'm sure there is an easier, cleaner approach, but hey, i'm a newbie yet). The user then saves the workbook, exits and re-opens, disabling the macros. They then activate the ME macro to start the copy process. As the copy function comes to the end of a row, when the Enter command is called to go back to column A in the next row, it is now pasting the last piece of copied data into the next Excel cell. Is there some setting within Excel that would change the functionality of the Enter key to paste? The last cell in the row did have a DV list attached to the cell prior to running the macro to remove it...did it leave a 'ghost'? Thanks! -- Trixie ~TRIXIE ------------------------------------------------------------------------ Trixie's Profile: http://www.thecodecage.com/forumz/member.php?userid=438 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116018 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
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) |