Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code to replace Past Special
I have a range of cells (ie. A1:A5) which can contain names. In cell B1:B5.
I use VLOOKUP to find the name in a table, and insert the value to the right of the name in the table into the active cell, (ie B1). The only problem is that later, the user will want to copy and paste the value in cell B1 to somewhere else on the spreedsheet. I can have the user copy and past special, but this requires too much thought on the part of the user. I'm looking for some code that will take the active cell, (B1), and say: Use the name to the left of the active cell, Find the name in the table, Take the value to the right of the name in this table Paste in into cell B1 as a value, (not a formula). active cell table A1 B1 C1 D1 ------------------------------------------------------------- Jones 101 Jones 101 Smith 201 White 301 Now the user could copy and paste without using past special. -- Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Past Special- Transpose Function? | Excel Discussion (Misc queries) | |||
past special | Excel Worksheet Functions | |||
Past Special Concatenated formula | Excel Discussion (Misc queries) | |||
automated copy and past special feature | Excel Programming | |||
Past Special changes results for macros... how to prevent this | Excel Programming |