Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macros not performing correctly
I recorded a macro to place a vlookup formula in four cells that are side by
side. When I run the macro it only performs the first task, it does not go on to do the other three. I used the tab key to go to the next cell while recording the macro, I don't know if that's why it's not working or if it's something else. The script looks like this: Sub EERates() ' ' EERates Macro ' Macro recorded 3/4/2005 by BCBSOK ' ' ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Sheet1!R3C1:R102C2,2,0)" Range("F15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],Sheet1!R3C4:R102C5,2,0)" Range("G15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-4],Sheet1!R3C7:R102C8,2,0)" Range("H15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-5],Sheet1!R3C10:R102C11,2,0)" Range("E16").Select End Sub Any help would be appreciated! Thanks! |
#2
|
|||
|
|||
If you intended to be using a single range to function with all of the
VLOOKUP formulas, you did not get that.......you evidently entered your lookup range as "relative referenced" cells, rather than "absolute referenced" cells, or better yet, a RangeName.........try something like: =VLOOKUP(D13,$A$3:0$B$102,2,0) Vaya con Dios, Chuck,CABGx3 "fabulousk" wrote in message ... I recorded a macro to place a vlookup formula in four cells that are side by side. When I run the macro it only performs the first task, it does not go on to do the other three. I used the tab key to go to the next cell while recording the macro, I don't know if that's why it's not working or if it's something else. The script looks like this: Sub EERates() ' ' EERates Macro ' Macro recorded 3/4/2005 by BCBSOK ' ' ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Sheet1!R3C1:R102C2,2,0)" Range("F15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],Sheet1!R3C4:R102C5,2,0)" Range("G15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-4],Sheet1!R3C7:R102C8,2,0)" Range("H15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-5],Sheet1!R3C10:R102C11,2,0)" Range("E16").Select End Sub Any help would be appreciated! Thanks! |
#3
|
|||
|
|||
My Vlookup formula is performing correctly.
I believe the problem lies in turning the relative reference button off/on. At home, in a newer version of Excel, it gave me a relative reference button and my formula worked. At work, I do not get a relative reference button and it's not working. How do I get the relative reference button? I'm using Excel 2000 at work, maybe it does not have such a button? "CLR" wrote: If you intended to be using a single range to function with all of the VLOOKUP formulas, you did not get that.......you evidently entered your lookup range as "relative referenced" cells, rather than "absolute referenced" cells, or better yet, a RangeName.........try something like: =VLOOKUP(D13,$A$3:0$B$102,2,0) Vaya con Dios, Chuck,CABGx3 "fabulousk" wrote in message ... I recorded a macro to place a vlookup formula in four cells that are side by side. When I run the macro it only performs the first task, it does not go on to do the other three. I used the tab key to go to the next cell while recording the macro, I don't know if that's why it's not working or if it's something else. The script looks like this: Sub EERates() ' ' EERates Macro ' Macro recorded 3/4/2005 by BCBSOK ' ' ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Sheet1!R3C1:R102C2,2,0)" Range("F15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],Sheet1!R3C4:R102C5,2,0)" Range("G15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-4],Sheet1!R3C7:R102C8,2,0)" Range("H15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-5],Sheet1!R3C10:R102C11,2,0)" Range("E16").Select End Sub Any help would be appreciated! Thanks! |
#4
|
|||
|
|||
I found it on another post. It has to do with the stop recording toolbar.
Yeah! It's working now. "fabulousk" wrote: My Vlookup formula is performing correctly. I believe the problem lies in turning the relative reference button off/on. At home, in a newer version of Excel, it gave me a relative reference button and my formula worked. At work, I do not get a relative reference button and it's not working. How do I get the relative reference button? I'm using Excel 2000 at work, maybe it does not have such a button? "CLR" wrote: If you intended to be using a single range to function with all of the VLOOKUP formulas, you did not get that.......you evidently entered your lookup range as "relative referenced" cells, rather than "absolute referenced" cells, or better yet, a RangeName.........try something like: =VLOOKUP(D13,$A$3:0$B$102,2,0) Vaya con Dios, Chuck,CABGx3 "fabulousk" wrote in message ... I recorded a macro to place a vlookup formula in four cells that are side by side. When I run the macro it only performs the first task, it does not go on to do the other three. I used the tab key to go to the next cell while recording the macro, I don't know if that's why it's not working or if it's something else. The script looks like this: Sub EERates() ' ' EERates Macro ' Macro recorded 3/4/2005 by BCBSOK ' ' ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Sheet1!R3C1:R102C2,2,0)" Range("F15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],Sheet1!R3C4:R102C5,2,0)" Range("G15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-4],Sheet1!R3C7:R102C8,2,0)" Range("H15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-5],Sheet1!R3C10:R102C11,2,0)" Range("E16").Select End Sub Any help would be appreciated! Thanks! |
#5
|
|||
|
|||
Glad to hear all is well..............thanks for the feedback
Vaya con Dios, Chuck, CABGx3 "fabulousk" wrote in message ... I found it on another post. It has to do with the stop recording toolbar. Yeah! It's working now. "fabulousk" wrote: My Vlookup formula is performing correctly. I believe the problem lies in turning the relative reference button off/on. At home, in a newer version of Excel, it gave me a relative reference button and my formula worked. At work, I do not get a relative reference button and it's not working. How do I get the relative reference button? I'm using Excel 2000 at work, maybe it does not have such a button? "CLR" wrote: If you intended to be using a single range to function with all of the VLOOKUP formulas, you did not get that.......you evidently entered your lookup range as "relative referenced" cells, rather than "absolute referenced" cells, or better yet, a RangeName.........try something like: =VLOOKUP(D13,$A$3:0$B$102,2,0) Vaya con Dios, Chuck,CABGx3 "fabulousk" wrote in message ... I recorded a macro to place a vlookup formula in four cells that are side by side. When I run the macro it only performs the first task, it does not go on to do the other three. I used the tab key to go to the next cell while recording the macro, I don't know if that's why it's not working or if it's something else. The script looks like this: Sub EERates() ' ' EERates Macro ' Macro recorded 3/4/2005 by BCBSOK ' ' ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Sheet1!R3C1:R102C2,2,0)" Range("F15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-3],Sheet1!R3C4:R102C5,2,0)" Range("G15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-4],Sheet1!R3C7:R102C8,2,0)" Range("H15").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-5],Sheet1!R3C10:R102C11,2,0)" Range("E16").Select End Sub Any help would be appreciated! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) |