ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Macro Assistance (I am desperate) (https://www.excelbanter.com/excel-programming/312341-vba-macro-assistance-i-am-desperate.html)

adncmm1980[_2_]

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


Tom Ogilvy

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