![]() |
VBA Macro Assistance (I am desperate)
Dear Guys (and anyone reading this post) Thank you to the both of you for replying to my message :) :cool: Tom Ogilvy I can see now that I am only referencing row 2 in my code for column B,C,D. however, unfortunatley as I am an idiot I do not have a clue o how to amend my code to get it to pick up the rest of my data with m loop. I would be very grateful of any assistance you can offer. N10 I have commented those lines out as they where part of the orginal cod that I wrote, what I probably should done was delete them to avoi confusion. Please accept my apologies Kindest Regards Andre -- adncmm198 ----------------------------------------------------------------------- adncmm1980's Profile: http://www.excelforum.com/member.php...fo&userid=1496 View this thread: http://www.excelforum.com/showthread.php?threadid=26591 |
VBA Macro Assistance (I am desperate)
It is hard to tell.
you find one variable he straccount = objws.Cells(foundrow, 1).Value on the sheet objws, but then you refer specifically to a sheet Worksheets("Template") for your other variables. I don't know if objws and Worksheets("Template") are one and the same. If not, then I certainly don't know how I would find the correct row on Template just by reading you code. -- Regards, Tom Ogilvy "adncmm1980" wrote in message ... Dear Guys (and anyone reading this post) Thank you to the both of you for replying to my message :) :cool: Tom Ogilvy I can see now that I am only referencing row 2 in my code for columns B,C,D. however, unfortunatley as I am an idiot I do not have a clue of how to amend my code to get it to pick up the rest of my data with my loop. I would be very grateful of any assistance you can offer. N10 I have commented those lines out as they where part of the orginal code that I wrote, what I probably should done was delete them to avoid confusion. Please accept my apologies Kindest Regards Andrew -- adncmm1980 ------------------------------------------------------------------------ adncmm1980's Profile: http://www.excelforum.com/member.php...o&userid=14965 View this thread: http://www.excelforum.com/showthread...hreadid=265919 |
All times are GMT +1. The time now is 10:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com