May I have a code that it will put a paticular text say "totals" to the first blank cell in the that row. My data changes weekly. I put a sample workbook below.
May I have a code that it will put a paticular text say "totals" to the first blank cell in the that row. My data changes weekly. I put a sample workbook below.
[VBA]
ActiveSheet.[a1].End(xlToRight).Offset(0, 1) = "totals"
[/VBA]
Thank You very much.
You're most welcome!
Hey Shazam...this sounds like it is putting the criteria for those searches I helped you with....sounds like you might be getting closer to being done...Hope it is coming together okay.
Pete
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Originally Posted by XLGibbs
I think its done but its kind of hard to anticipate every problem untill it happends. When I put all the codes together it works well but when a new updated workbook comes from our customer then the code bombs. So I adjust the code then it works. Then another workbook comes then the codes fails again so I'm trying to anticipate every move from our customer. Just too bad we dont have the luxury to tell the customer what we want. Of course the knowledge I'm learning from you and the others on this forums is really helping so I dont have to post a new thread all the time. I got about 7 books of formulas and vba's also I spend some hours on net to fnd a solution when I can't find one or I'm not looking at the right place then I post a question. But once again thank you and the others who has help me here.
How come the code bombs? Probably an issue with sheet names and the location of the data I suppose...at least you are learning something along the way!
You are welcome for the assistance, of course.
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Its not the code but the customer sending the workbook they're keep changing the format just enough for the code bombs.
How typical is that! You would think they would wanta consistent format as well....
anyways...good luck, let us know what else we can help with!
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Posting Permissions
Reply With Quote
