Search results for query: *

Just noticed that! I like the fact that you do stuff like that on this site, very cool! Thanks again SkipVought and Gavona for the heads up!

Beautiful, thank you again! I really appreciate the time you took to help :)

SkipVought your way is totally better! Thanks!

OK I figured it out! Thank you everyone for your support and ideas! Note the reason why this works in my case is because a simple pastespecial values in code did not work as my workbook activate and deactive code disables and enables shortcuts, toolbars, etc. I also deactivated the right click...

Ok, tried that. I set application..OnKey "^v", "CopyFunc" then i used your code Public Sub CopyFunc() ActiveCell.PasteSpecial xlPasteValues End Sub I put a toggle break to make sure this was being used upon Ctrl+v (I disabled right click on the cell as well as the menu function to force...

But I only want values pasted, not formats My application runs other macros upon workbook activate/deactivate, when I run a simple Ctrl+v the format of the cells from the other book (including locked cell by default) goes into my application which sheet is protected. Therefore a user cannot copy...

Sorry, but again this is the code used to paste the data in (I have this being called when a user hits Ctrl+v) I wouldn't see how the EDIT is being used? Sub myFunc() Set MyData = New DataObject MyData.GetFromClipboard On Error GoTo ERRHANDLER strClip = MyData.GetText(1)...

I gave that code to show you the result of the original code in my first post (I guess you did not run it?) The result is a duplication of the code I pasted just recently, and as explained before I have multiple rows so text to columns will not work

ok...can someone please paste the following code into a module and run it to see what I am working with? I want to split out this data into rows and columns (anywhere from 1 to 4 columns, up to 50,000 rows) Sub pastedvalex() ActiveCell.Value = "col1row1" & Chr(1) & "col2row1" & Chr(1) &...

Not sure what you mean with Editing the cell....were you answering me or PHV? I want the data to be pasted from wherever they click as a starting point, moving over the same number of columns and rows as the data they are copying from. Right now it is only pasting into one cell, and text to...

If I use the text to columns function when the original cell has more then one line (lines are separated with Alt+Enter), Excel does only notice the first line.

I see where you are going with this, but let me explain a bit more about the application. It is a shared book on the server used by over 200 Sales reps. At one point we ask them to enter client shipment information. They open up an excel book that the client sent them (therefore, a second...

Wow sorry for offending you...that is what I meant. Not sure if you noticed but I am a new user, please don't yell at me :) I did step 1, and put my above code in a module I did step 2, typed in random data into cells, copied them, and clicked on the first INSTANCE of excel (ie workbook) and...

I unfortunately cannot keep this in the same excel book.... This is for a program I am developing where users are to copy data from one excel book and import it into my application. Because the users may paste one column at a time, or for the most part only a part of their data file is...

thread707-1380005 I used the code in the above thread and it gives me a message box showing the data stored in memory. However, I want to paste the data and I am having problems. I tried using ActiveCell.Value = MyData.GetText(1) as well as ActiveCell.Value = Selection but I am getting all the...