| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and paste - help with code
Make the column wider. If that doesn't work,
Look at the value stored in the cell. Format the cell as General. What is in the Cell. -- Regards, Tom Ogilvy "Les Stout" wrote: Sorry Tom, just a further question, i am also using your code to copy over a date in the format 20070223, but on the KTL sheet where it gets copied to the cell format is set as "dd-mmm-yy" and when it copies it in it just shows ################ is there a way around this ?? Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a Unique code cut and paste | Excel Discussion (Misc queries) | |||
| Find/Copy/paste.. then Find/Paste - not working ... at all.... | Excel Programming | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| code to FIND value, copy, paste values onto other sheet | Excel Programming | |||
Threaded Mode
