LinkBack URL
About LinkBacks
Hi,
Below is my script and its not stopping once the data is over.....Please help me on this and correct me where I am going wrong
Please Login or Register to view this content.
Hi,
Below is my script and its not stopping once the data is over.....Please help me on this and correct me where I am going wrong
Please Login or Register to view this content.
Last edited by vimalanathk; 12-03-2013 at 01:13 AM.
Hi, vimalanathk,
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi,
Not sure exactly what you are trying to do but I'm assuming that you want to copy down a formula until you find the word "Powered by GL Compliance Manager" in another column assuming its column L.
Try this if you want the formula to be next to column K.
Thanks,Please Login or Register to view this content.
Fonzie
Hi, vimalanathk,,
you compare the contents of Range(C2) constantly - is this calculated by formula or a constant value found in Column C? Maybe try it like this or post a sample of your workbook:
Alternative code:Please Login or Register to view this content.
You should consider any other variable as Row is part of the VBA vocabulary.Please Login or Register to view this content.
Ciao,
Holger
Last edited by HaHoBe; 12-03-2013 at 01:31 AM.
I tried all the codes given in replies but the loop is not stopping and its going to end of excel sheet.
Please find the example sheet of my data and help me on the same.
Regards,
Vimala K
This should do it based on the file you provided.
Thanks,Please Login or Register to view this content.
Fonzie
Hi, Vimala K,
no need for any loop IMO:
@Fonzie:Please Login or Register to view this content.
I doubt your code is taking care of Column K being filled?
Ciao,
Holger
Hi,
Attached is my solution. Hope this helps.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
Just a side note on your original code, the code doesn't stop because you did not increment row variable so it's forever looking at row 2.
Thanks Ciao Holger!
Vimalanathk,
Try out this code.
Thanks,Please Login or Register to view this content.
Fonzie
Last edited by fonzie29; 12-03-2013 at 02:45 AM.
Your bottom code is giving me the output for blank line of status columns also where i need the out put only the status is updated... it should be blank for status blank line items.
Regards,
Vimala K
Hi Fonzie,
I just changed your script with my requirement and I am getting the output.
Thanks a lot for your help.
Regards,
Vimala K
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks