$$Excel-Macros$$ about & operator

hi, i writing below code for a function but it don't runing..where is the problem..can you help me? function car(dnm) tablo1 = 19 / 12 / 2008 For i = 2 To 9 tablo& i = tablo1 + i - 1 Next i tablo10 = tablo1 + 11 if dnm = "K1" Then car = tablo2 elseif dnm = "K2" then c

$$Excel-Macros$$ Re: about & operator

TOM, THANK YOU VERY MUCH , ONLY PERFECT --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://group

$$Excel-Macros$$ two sheets date in the one sheets

hi, i have 5 sheets and columns A and B have same title's data, for example column A have Name and Column B have Birthday, but i have a lot of sheets and that data not be long and i can put all data in a sheet.Can i do that easly with menu of excel? --~--~-~--~~~-

$$Excel-Macros$$ Re: two sheets date in the one sheets

Thank you very much TOM JEFFRIES... On 24 Aralık, 18:16, "Tom Jeffries" wrote: > The attached workbook contains a macro (CombineWorksheets) that may do what > you want.   If you have any questions let me know. > Tom > > On Wed, Dec 24, 2008 at 8:28 AM, 2008r

$$Excel-Macros$$ about if ...then with iserror

Hi, i have two sheets and i have tables in that sheets...and my table like below format.and i wanna write sheet1's costs in sheet2 cost area...but that sheet2 's name sometimes not equal that sheet1's name and sometimes sheet1 not have sheet2's name , i was write that below code but that is give

$$Excel-Macros$$ Re: about if ...then with iserror

THANK YOU VERY MUCH THAT IS REALLY PERFECT BUT CAN YOU EXPLAIN ME THAT ABOUT "VLOOK" AND "ON ERROR RESUMEN NEXT " .PLEASE GRACIAS --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send

$$Excel-Macros$$ Re: about if ...then with iserror

again thank you --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel

$$Excel-Macros$$ i cannot write with E , for example 11E17

Hi I have a problem with my goods's code.my goods's code is that bellow codes and that codes make a problem with Excel when i take report from my database.. In database ın excel 11E15 1,10E+12 11E16 1,10E+13 11E20 1,10E+20 I want to write that goods's code in E

$$Excel-Macros$$ Write a text from a sheet to another sheet

hi group of excel's members i hope your everything be EXCELlent. i have two sheets.that sheets name are Sheet1 and Sheet2. i have texts in column B of sheet1 and i wanna write same texts in sheet2 . i was write bellow code but it is not write that texts in sheet2. Sub WriteShe2() Sheets("sheet

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

i was try the cell text format.but that value is change 1100 (for 11E17) when i do it. i know that problem is give me for scientific notation i was write that VBA for text format but that is not work. --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: i cannot write with E , for example 11E17

problem is that i take my code's report from my database , i don't write these codes with myself. if someone want to file about that , i can send a excel file. thanks for your helps. --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ add from excel cell to listbox

hi eveyone, i have a list in my column(b:b) of sheet of excel and there are so much names in that list. i want to put a textbox and a listbox on a userform and i want to write a name in that textbox and i want to search that name in my list and i want to see that search's names completys in my l