Re: $$Excel-Macros$$ Error in Excel-VB macro

- > > > > > > > > *“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 > you can,As long as ever you can.” - John Wesley* > -------

Re: $$Excel-Macros$$ Giving error in renaming sheet using VBA

Thanks Sharmaji, On Sat, May 16, 2015 at 4:45 PM, Pankaj Sharma wrote: > Done!!! > > > > > > Regards > > > > Pankaj Sharma > > > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ITP Abdu

Re: $$Excel-Macros$$ Macro should not create new sheet without complete data fill in existing

= "" Or Range("V1").Value = > "" Or Range("V2").Value = "" Then > Exit Sub > End If > > > On Tue, May 12, 2015 at 9:29 AM, ITP Abdulgani Shaikh < > itpabdulg...@gmail.com> wrote: > >> Thanks for your rep

Re: $$Excel-Macros$$ Re: Want to disable copy, cut & paste

Thanks Michael, I will go through it and will update. On Sat, Feb 14, 2015 at 1:38 AM, michael vinoth wrote: > Hi Abdulgani, > > Please check this.. > > http://www.asap-utilities.com/excel-tips-detail.php?categorie=9&m=85 > > On Friday, February 13, 2015 at 11:51:05 AM UTC+5:30, ITP Abdulgani wr

Re: $$Excel-Macros$$ Want to disable copy, cut & paste

c0-41ba-bb69-80f6b34ed775&ui=en-US&rs=en-IN&ad=IN > > > On Fri, Feb 13, 2015 at 3:48 PM, ITP Abdulgani Shaikh < > itpabdulg...@gmail.com> wrote: > >> but how ? >> >> On Fri, Feb 13, 2015 at 1:41 PM, Vaibhav Joshi wrote: >> >>> You can protec

Re: $$Excel-Macros$$ Want to disable copy, cut & paste

but how ? On Fri, Feb 13, 2015 at 1:41 PM, Vaibhav Joshi wrote: > You can protect sheet/wb and disable cut/copy /paste.. > > On Fri, Feb 13, 2015 at 11:50 AM, ITP Abdulgani Shaikh < > itpabdulg...@gmail.com> wrote: > >> I want to disable copy, cut & paste in the

Re: $$Excel-Macros$$ If cell is blank, it should give error msg

he same password > > ActiveSheet.Protect "MySheetPassword" > > Pada 10/09/2013 22:09, ITP Abdulgani Shaikh menulis: > > Yes got it, but active sheet is password protected, any solution for > that. > > > On Tue, Sep 10, 2013 at 8:29 PM, De Premor wrote

Re: $$Excel-Macros$$ If cell is blank, it should give error msg

. > > *ActiveSheet*.Protect > > > Pada 10/09/2013 21:52, ITP Abdulgani Shaikh menulis: > > Dear Sir, > This sheet is again giving problem, please see attachments. When I am > additing sheet and running CHECK macro, it gives error on new added sheet. > Regards > > >

Re: $$Excel-Macros$$ If cell is blank, it should give error msg

vbQuestion) = vbYes Then > UserInput = Application.InputBox("Input PANo !", "PANo", > Type:=1) > If Not UserInput = False Then > PANo = UserInput > PANo.Interior.Pattern = xlNone > End If >

Re: $$Excel-Macros$$ Indian Salary TDS calculator for FY 2013-14

from EXCEL point of view. Regards On Thu, Aug 22, 2013 at 2:17 PM, ITP Abdulgani Shaikh < itpabdulg...@gmail.com> wrote: > Dear Excel Masters, > > Please find attached herewith Salary TDS calculator for FY 2013-14. I am > not expert in VB, but just tried to make this sheet namely

Re: $$Excel-Macros$$ Sortring out worksheets in ascedning order

Gr8, can please tell me, if I want to ignore first two sheet while sorting ascending or descending. How to do it ? On Fri, May 24, 2013 at 4:50 PM, Abhishek Jain wrote: > Check this. > > > On Fri, May 24, 2013 at 4:38 PM, Prabhakar S H wrote: > >> Hi Team, >> >> Plese check and tell me is it pos

$$Excel-Macros$$ How to create hyperlink within workbook

I have created hyperlink, using formula but it is not working, whats going wrong ? I want to create hyperlink within workbook, that workbook will be used by different people on different server. Please guide. Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =

Re: $$Excel-Macros$$ INCOME TAX HELP

also you will find people doing job like this on www.incometaxindia.gov.inLOCATE TRP section and www.trpscheme.com On Fri, Jun 1, 2012 at 2:32 PM, Abdulgani Shaikh wrote: > Dear Mr Tarun, > > This is already discussed in this forum. You will find free utilities > available on NSD

Re: $$Excel-Macros$$ Extracting a word from the cell.......

This is really great ! Suppose I want extract 2nd or 3rd or 4th word, then ? Regards On Wed, Jul 11, 2012 at 9:39 AM, Mohammed Muneer wrote: > Dear Don, > > Superb & Innovative. > > Keep it up! > > Both code and formula good. > > ** ** > > ** ** > > *“Experience is the mother

Re: $$Excel-Macros$$ Introduce Yourself !!

Sorry for late. Myself Shaikh AbdulGani A.R., working as Taxation Manager also practicing as Tax Consultant in field of Income-tax, TDS and MH VAT. This group helped me a lot for making lot of templates for smooth working. Regard On Wed, Jun 13, 2012 at 3:47 PM, Tinusz Tamás wrote: > Hi all

Re: $$Excel-Macros$$ INCOME TAX HELP

Dear Mr Tarun, This is already discussed in this forum. You will find free utilities available on NSDL website on following link : https://www.tin-nsdl.com/etds-etcs/eTDS-download-regular.php Regards On Fri, Jun 1, 2012 at 1:58 PM, Anil Gawli wrote: > pls give me the output of the report,

Re: $$Excel-Macros$$ Poem- Happy Birthday Ayush...........

Fantastic, Noorainbhai, Wish you many many belated happy birthday Ayush, you have really done good job by creating this group Regards 2012/4/26 bhupendra singh raghav > Kyaa bat hai noorian bhai... > > > > On Thu, Apr 26, 2012 at 9:12 PM, NOORAIN ANSARI > wrote: > >> >> >> हरदम हँसते मुस्कुरा

Re: $$Excel-Macros$$ Re: Block cell editing

I am new to this, can you please explain in detail how to do this Regards On Tue, Apr 24, 2012 at 2:47 PM, CoRe wrote: > Hello Rd > > > In the Review tab , Protect Workbook/Structure , create a password , after > in the same tab go on Protect Sheet create a password and it is done. > > > > On Tu

Fwd: $$Excel-Macros$$ INCOME TAX SOFTWARE

Dear Tarun I have found this one made by Mr.Pranab, please get is verified before using it. I have not made this, but found useful to you. If you are having large no.of employees for whom you need this, always buy software or ask professionals to do this job. Free excel utility will not do much

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

Thanks a lot Sir, I am updating my sheets and will get back to you. Regards On Sun, Apr 15, 2012 at 10:13 PM, dguillett1 wrote: > If your request is for a reply, I did reply. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > >

Re: $$Excel-Macros$$ Fwd: If data in One then another cell to be unlock

> > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Abdulgani Shaikh > *Sent:* Apr/Sun/2012 03:14 > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Fwd: If data

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

Pl.reply On Sat, Apr 14, 2012 at 2:02 PM, Abdulgani Shaikh wrote: > I have pasted this in Excel, but it is not working, pl.find attached file, > where i am wrong ? > Regards > > > On Sat, Apr 14, 2012 at 12:38 PM, Rajan_Verma wrote: > >> Hi,

Re: $$Excel-Macros$$ Fwd: If data in One then another cell to be unlock

Windows:=False > End Sub > Sub NextSheetSAS() > On Error Resume Next > Sheets(ActiveSheet.Index + 1).Activate > If Err.Number <> 0 Then Sheets(1).Activate > End Sub > Sub PreviousSheetSAS() > On Error Resume Next > Sheets(ActiveSheet.Index - 1).Activate > If Er

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Abdulgani Shaikh > *Sent:* Apr/Sat/2012 02:03 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ If date in One then another cell to be > unlock > &g

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

. Also tell me what is private sub function in macro. Regards On Sat, Apr 14, 2012 at 3:48 PM, Abdulgani Shaikh wrote: > Pl.reply > > > On Sat, Apr 14, 2012 at 2:02 PM, Abdulgani Shaikh > wrote: > >> I have pasted this in Excel, but it is not working, pl.find attached &

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

ocked = True > > End If > > End If > > Me.Protect > > End Sub > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ITP Abdulgani Shaikh > *Sent

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

Heartiest congratulations !!! On Sat, Apr 14, 2012 at 2:13 PM, Rajan_Verma wrote: > Congrats DON > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ayush Jain > *Sent:* Apr/Sat/2012 02:06 > *To:* excel-macros

Re: $$Excel-Macros$$ If date in One then another cell to be unlock

Pl.find attached sample file On Sat, Apr 14, 2012 at 12:19 PM, ITP Abdulgani Shaikh < itpabdulg...@gmail.com> wrote: > Dear Freinds, > > Please help me on following issue > > My worksheet is protected, out of all cells, some cells are unprotected > for entering data. &g

$$Excel-Macros$$ If date in One then another cell to be unlock

Dear Freinds, Please help me on following issue My worksheet is protected, out of all cells, some cells are unprotected for entering data. If I am entering data in Cell C3 then Cell E3 should be auto unlock the cell. and if there is no data in Cell C3 or zero in C3 then Cell E3 should be auto loc

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

can you > incorporate this codes for MS-Excel? > > Thanks @ dguillett1, but I'm not able to use the same code for Logout > time tracking in a different column, can you please help me once again? > > @ Abdulgani Shaikh, I have attached the same file in .xls format. > >

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

Hearty Congratulation for doing such great job. I myself learn VBA through this forum only. Can you please tell me something more on Microsoft MVP Excel Regards On Thu, Mar 22, 2012 at 4:25 AM, Ayush Jain wrote: > Dear members,** > > > > I am proud to announce that the forum has co

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Excellent, expert in Excel as well expert Poet What a combination...Great. 2012/3/23 Venkat CV > Dear Noorain, > > Superb > > *Best Regards,* > *Venkat * > *Chennai* > > > 2012/3/23 NOORAIN ANSARI > >> जहाँ Excel के दीवानों की, है बहूत घनी आबादी. >> जहाँ Question,Answer करने की,है ख

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Really you are helpful, no prompt helpful, no full of helping nature. Hearty congratulation !!! On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He has posted 175 posts in Jan'12 and he

Re: $$Excel-Macros$$ Display numbers in Lakhs

This is really good, but gives answer in million format and not in Indian lakh. Regards On Sun, Jan 29, 2012 at 11:35 AM, Mohammed Muneer wrote: > Mr. Prabhu go to Format cells: > > Go to "Numbers - currency - select Indian RUPEES - Then immediately come > out from currency and go to customs - do

Re: $$Excel-Macros$$ ExcelTest

Dear Noorain, Please provide ansers also. Regards On Tue, Jan 31, 2012 at 7:58 AM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Excel Test to analyze you excel Skills. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ How to create Form for storing data

SalesAid Software > dguille...@gmail.com > > *From:* ITP Abdulgani Shaikh > *Sent:* Wednesday, December 21, 2011 2:38 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ How to create Form for storing data > > Dear Friends, > > I am Tax Practitioner.

$$Excel-Macros$$ Excel to PDF

Dear Noorain, I have gone through your code of Excel to PDF, but it is not working. Please guide where I am wrong. Sub exltopdf_converter() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, ".") - 1) ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:

Re: $$Excel-Macros$$ Re: Want to hide entire row

Cells(i, "I") >= 0 And Cells(i, "L") >= 0 Then > Rows(i).Hidden = True > else > Rows(i).Hidden = False > End if > > Regards, > Sam Mathai Chacko > > On Sun, Dec 4, 2011 at 3:27 PM, AbdulGani Shaikh > wrote: > >> Thanks Si

Re: $$Excel-Macros$$ Re: Want to hide entire row

uot;* OR *"L"* is positive,* *then how to show that particular row ? Regards On Sun, Dec 4, 2011 at 3:13 PM, AbdulGani Shaikh wrote: > Thanks Sir, > Its working, but it also hide its heading, is there any solution for not > to hide Column heading. (First three rows are h

Re: $$Excel-Macros$$ Re: Want to hide entire row

rue > End Sub > > Sub UnhideRows() > Rows.Hidden = False > End Sub > ‘==== > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* AbdulGani Shaikh > *Sent:* Thursday, December 01, 2011 9:45 PM > *To:* excel-macros@googlegroups.com > *Subje

$$Excel-Macros$$ Re: Want to hide entire row

Pl.help On Thu, Dec 1, 2011 at 4:41 PM, Abdulgani Shaikh < abdulgani.sha...@sarda.co.in> wrote: > I want to hide entire row if value in column "*I*" & column "*L*" is > greater than or equal to "*0*". > In other words if value in column i &