Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Expert , Can you expline the bold line as i want to know deeply. Function Reverse(Text As String) As String Dim i As Integer Dim StrNew As String Dim strOld As String strOld = Trim(Text) For i = 1 To Len(strOld) * StrNew = Mid(strOld, i, 1) StrNew* Next i

Re: $$Excel-Macros$$ Query - How to make reversal string.

Hi, It is working fine. In Cell A3 data is 958321.1 which is reversed as 1.123859. Pl check confirm. Thanks!! On Mon, Jul 22, 2013 at 10:55 AM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear VbA, thanks for your help. but this formula is not working properly.

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear VBA, Thanks for your help and valuable support. this is woking fine. Thanks, Ashish On 22 July 2013 11:44, vba v...@vabs.in wrote: Hi, It is working fine. In Cell A3 data is 958321.1 which is reversed as 1.123859. Pl check confirm. Thanks!! On Mon, Jul 22,

Re: $$Excel-Macros$$ Query - How to make reversal string.

Dear Seniors, Thank to all of you. Your help means a lot for me. thanks. thanks, Ashish On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote: Hi, It is working fine. In Cell A3 data is 958321.1 which is reversed as 1.123859. Pl check confirm. Thanks!!

$$Excel-Macros$$ doubt with regard to change event of the combo

Hai everyone I attached an excel sheet which contains a form. In that I placed three nos. of combo boxes. Each have its values. when I change the gp combo value the remaining two combo values should automatically change. I tried in many ways but failed. please help me out. regards shankar

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

What is your criteria? Suppose I select one value in gp combo, what values should be selected in the other two? On Mon, Jul 22, 2013 at 12:20 PM, Shankar Bheema shankar.n...@gmail.comwrote: Hai everyone I attached an excel sheet which contains a form. In that I placed three nos. of combo

Re: $$Excel-Macros$$ Query - How to make reversal string.

Respected Ashish, Simply use the attached add-in. On Mon, Jul 22, 2013 at 12:00 PM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Seniors, Thank to all of you. Your help means a lot for me. thanks. thanks, Ashish On Monday, July 22, 2013 11:44:56 AM UTC+5:30, Vabz wrote:

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

Respected Bheema Shakar, Please check the links which will help with your problem. http://www.contextures.com/exceluserformdependentcomboboxes.html http://www.youtube.com/watch?v=eJslb49T0Bk Regards, VIjaykuar On Mon, Jul 22, 2013 at 12:20 PM, Shankar Bheema shankar.n...@gmail.comwrote: Hai

$$Excel-Macros$$ Need MP file templates

Hi experts pls help me with manpower planning file templates. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Re: NEED FORMUALE TO PLACE DIFFERENT TYPE OF BOTTLES IN ROWS (NO DIFFERENT BOTTLES ON SAME ROW)

Dear Excel experts, Kindly help Regards Vijay yadav On Friday, 19 July 2013 13:57:52 UTC+5:30, vijay yadav wrote: Dear CGMAURYA, The file is attached along with this post. All details are mentioned below and same is also mentioned in my first post along with attached file. Regards

Re: $$Excel-Macros$$ Query - How to make reversal string.

Hi, if you want through VBA then you can use below function  Function reversetext(rtext As String) reversetext = StrReverse(rtext) End Function thanks and regards Ravinder Negi From: Prafull Jadhav prafulltjad...@gmail.com To: excel-macros@googlegroups.com

$$Excel-Macros$$ index and match in VBA

Hello VBA You solution was perfect. thanks for the help, am really grateful. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ Need help

Thanks Ravinder :) On Mon, Jul 22, 2013 at 4:05 PM, ravinder negi ravi_colw...@yahoo.comwrote: PFA.. -- *From:* Dhaval Shah todhavals...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, July 22, 2013 3:46 PM *Subject:* $$Excel-Macros$$ Need

Re: $$Excel-Macros$$ spit varios sheets of one excel file to related other excel file

Try this code Change Strpath as per your Path Sub creatnewWkb() Dim wkb As Workbook Dim strpath As String Dim wks As Worksheet Dim wkbnwebook As Workbook Set wkb = ThisWorkbook strpath = wkb.Path For Each wks In wkb.Worksheets wks.Copy wks.Paste ActiveWorkbook.SaveAs _

Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

Hi vijay, PFA On Mon, Jul 22, 2013 at 8:26 AM, Vijay Gande vijaykumar.ga...@gmail.comwrote: Hi there, I'm amateur with excel macros and need help with the following task, I've an excel workbook with 16 sheets, all the sheets have same # of columns but different # of rows. My

$$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

Hi there, I'm amateur with excel macros and need help with the following task, I've an excel workbook with 16 sheets, all the sheets have same # of columns but different # of rows. My task is to copy the data from each of these 16 sheets and past in the consolidate sheet in the same

$$Excel-Macros$$ spit varios sheets of one excel file to related other excel file

Dear Excel experts, I want one macro which can spit varios sheets of one excel file to related other excel file. I have one excel file where 10 sheets are available ex. a, b, c, d and I have files for same sheets ex. a, b, c, d. So I want to transfer a, b, c, d sheets to a, b, c, d file.