Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
Range("A1") = Workbookfunction(VLookUP(Range("A2",Range("M1:P5") ,2))
Just substitute the cell and range settings. You may want to use Range("A1").Value=............. hth -- steveB (Remove 'NOSPAM' from email address if contacting me direct) "hey" wrote in message ... I would like to see the writing for a macro that looks up a value in a table then copies it and pastes it to a certain cell. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
CONFUSING ME NOW. WHAT AM I DOING WITH WHAT YOU WROTE. THANKS
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
could you write it exactly as i need it, incorporating franks and yours
thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
Hi
he just gave you a statement which can be used within a macro. For a complete example see my post (Logic is very similar) -- Regards Frank Kabel Frankfurt, Germany HEY wrote: CONFUSING ME NOW. WHAT AM I DOING WITH WHAT YOU WROTE. THANKS |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
Hi Steve
what is 'workbookfunction' :-) you probably meant Range("A1").value = application.VLookUP(Range("A2").value,Range("M1:P5 "),2,0) (also clearing some typos and adding the 4th parameter to vlookup) -- Regards Frank Kabel Frankfurt, Germany steveB wrote: Range("A1") = Workbookfunction(VLookUP(Range("A2",Range("M1:P5") ,2)) Just substitute the cell and range settings. You may want to use Range("A1").Value=............. hth "hey" wrote in message ... I would like to see the writing for a macro that looks up a value in a table then copies it and pastes it to a certain cell. Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
Frank,
My bad... Meant to use WorksheetFunction. Have been home to long and the senior moments are piling up... Thanks for catching this. Don't want to confuse the user anymore than need be... -- steveB (Remove 'NOSPAM' from email address if contacting me direct) "Frank Kabel" wrote in message ... Hi Steve what is 'workbookfunction' :-) you probably meant Range("A1").value = application.VLookUP(Range("A2").value,Range("M1:P5 "),2,0) (also clearing some typos and adding the 4th parameter to vlookup) -- Regards Frank Kabel Frankfurt, Germany steveB wrote: Range("A1") = Workbookfunction(VLookUP(Range("A2",Range("M1:P5") ,2)) Just substitute the cell and range settings. You may want to use Range("A1").Value=............. hth "hey" wrote in message ... I would like to see the writing for a macro that looks up a value in a table then copies it and pastes it to a certain cell. Thanks |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
This works, but it still isnt a cut and paste. Is this possible to incorporate
Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
List the Macros that can be executed from Tools-Macros | Excel Programming |