Search results

Hi All, I've made excel file which has VBA codes. Create one button to "Cut first row from Sheet1 & Paste in Sheet2" (Sheet1 is veryhidden from Vba) 2nd button to "Work Done" it is for cut row from sheet 2 & paste in Sheet3. its working fine while using without shared. Now problem is rise...

Hi Guys, Hope you guys enjoying your life. I've a question and i am really stuck into it. before 2010 office i was using 2003 office. And there i wrote a VBA coding for easy reply to the customers. I've list of specific answers so i was made the buttons of answers in toolbar. Codes like...

Thank you so much....... & I'll for next time..! and its not working on the Shared workbook. thanks anyway...! have a good day..

Hi SirJB7, I appreciate your help, but there's something more which i need like. 1) I want Particular cell not whole sheet. (like "A1" & "C1") 2) then comment on cell 3) then finally cell locked for editing... and this is shared workbook.....!!! Thanks so much.....!

Hi, Can anybody help me on this? I've Shared workbook and i want if somebody change the particular cell ( cell has time value), put the comment on the cell and lock for editing automatically ("comment" should be user-name). I need this in VBA coding... Thanks for help in advance.....

Hi, Mahaveer You are the BEST......! Thanks so much for your help....! I'll back soon for another helpppppp :) Bhushan...

Hi Mahaveer, You've done awesome job again....!!! Thanks But i have one question, in VBA coding you are selecting "Sheet1.Activate". so its mean i have to give name sheet name which i have...!!!! but in my file there's always generate sheet by month on month...like...Jan's sheet, feb's...

Hey sorry one more thing....in your excel file, can we just copy all data n paste into another sheet, not deletion in first sheet?

Hi, Mahaveer Thanks for reply, and i know how to check vba coding, but when i go to the userform then i double click on the "commandButton1" i got the error " Object Library invalid or contains references to object definition that could not be found". i hope you can figure it out...

Thanks... mahaveer : that's awesome, but i am unable to see your coding....! can you please share the file without restriction?

Hi All, A very very happy new year to all of you....!! Can somebody help me for my project? Actually what i want, that i have couple of sheets in excel and column D have different dates in sheet1. so if i type in userform text box a single date, then if column D have these dates so...

Hi, Debraj, Thank you so much, i would never think about "sumproduct". I thought it would be solve only count,countif, countifs...! Thanks again.... And I need the same in vba because i want to make vba code which will reflect all time range cell count in "msg box"...

Hi All, Can somebody tell me that how can i count the cell if i've time range in entire row. Like 1:00 am 1:01 am 1:10 am 1:13 am........ 2:00 am 2:25 am So i want to know how many cell in between 1:00 am to 2:00 am. i would really thankful to you.....if is it in VBA it would be great.

Thanks For reply....But i m sorry i didn't understand.

Hi, Can anybody help me, I've received 500+ mail in one day. and i need to make report from these mails. i need importantly modify time and user id (system log in id) of each mail. It would be helpful if there's macro. Thanks Macro Beginner Bhushan