LinkBack URL
About LinkBacks
hi, ive got a 1004 problem on below yellow line, whats wrong with this ?
thanks
Please Login or Register to view this content.
hi, ive got a 1004 problem on below yellow line, whats wrong with this ?
thanksPlease Login or Register to view this content.
Last edited by hamex; 09-09-2010 at 01:24 PM.
Col is not initialized.
Please change your QUOTE tags to CODE tags.
Thanks.
Entia non sunt multiplicanda sine necessitate
You are using a variable Col for the row, and you have not given that variable a value yet.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
as my first message in my forums and breaking the forum rules i need to say , ive download the xls file from this address : http://www.excelforum.com/excel-prog...s-to-rows.html and got this error . im really sorry for inconvience but im in hurry ,... can you help me ?
What are you trying to do?
thank you for reply , i need to split the separated-comma rows (text to rows) but that gives me "Application defined or object defined error". you can see the attachment ..
thanks again
Split them to appear where?
in new sheet named "DATA1" , i was download this file from john's post at "http://www.excelforum.com/excel-prog...s-to-rows.html" and modify the target content and after that on line 100 of my previous post's attachment give me the error.
Please make this simple and post a partial example of the output as you wish it to appear.
No offense, can you download my attach file to see the exact problem ?
Try replaxcing all that code with this and see if it does what you want.
Please Login or Register to view this content.
Last edited by shg; 09-09-2010 at 02:26 PM.
thanks shg for your time, but this one not helping me and actually i need to solve the problem not change the whole program .
I see the Col variable is Public in another module. Perhaps if you move the macro into that module you'll get the stored value of Col.
Hi Hamex
I believe you'll find your error in this line of codeis due to the fact that once your row number exceeds 99, the formula in the offending line of code evaluates to 0 (zero).Please Login or Register to view this content.
Change that line of code toand you should be good to go.Please Login or Register to view this content.
John
PS: By the way, I tested Shg's code...it's much simpler than the code I wrote and it works wonderfully well.
Last edited by jaslake; 09-10-2010 at 04:53 PM.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
john thank you very much for your kindly help , its ok now and the prob is solved .. God bless you
Why not using Excel's builtin facilities ?
If the selection is restricted to cells in column B:
Please Login or Register to view this content.
Hi hamex
You're welcome. Thanks for the blessings.
John
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks