Re: $$Excel-Macros$$ macro to be edit

2016-11-24 Thread GENIUS
Sir, Thanks you very much for your help. Would you please suggest the best way for learning Macro and the videos, I have watched so many videos on macros but those videos are not so advanced. Thanks once again. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME

Re: $$Excel-Macros$$ macro to be edit

2016-11-23 Thread Paul Schreiner
You're not defining a delimiter.Are you using a comma (,) as the delimiter? then you need Comma:=true, Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people yo

Re: $$Excel-Macros$$ macro to be edit

2016-11-23 Thread GENIUS
you may see the attachment, I have made some changes in it, and then running the same but still not working. Would you please change it and then send it to me the changed copy, please don't mention in the email because I'm not so expert in macro NOTE: I'm using excel 2013 -- Are you =EXP(E:R

Re: $$Excel-Macros$$ macro to be edit

2016-11-22 Thread Paul Schreiner
It looks like it's a problem with your FieldInfo:= value. You have:FieldInfo:=Array(1, 1) when I recorded a macro, it used: FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)), when I modified it to fit in your macro, it worked. although, I suspect you should change your logic.Sta