Re: $$Excel-Macros$$ Solution required

Dear Subhash In addition to Rajan's excellent solution, if you just want to toggle between sheet 2 and 11, you can use hyperlink in both of the sheets. For this just type "Take me to Sheet 12" in any empty cells of Sheet 1 and right click on it. Hyper link >> Link to >> Place in this document >>C

RE: $$Excel-Macros$$ Solution required

1) Open Excel 2) Press ALT+F11 3) Press ALT+I M 4) Copy this Code 5) Paste it in that module 6) Come to worksheet 7) Press ALT+F8 8) Select GotoSheet and Run 9) It will show the sheet Name along with Number 10) Press ok 11) Fill the sh

Fwd: $$Excel-Macros$$ Solution required

*Dear Rajan* *Please elaborate how it will work.* *Thanks,* *Pravin Gunjal * -- Forwarded message -- From: Rajan_Verma Date: Sat, Oct 13, 2012 at 11:39 AM Subject: RE: $$Excel-Macros$$ Solution required To: excel-macros@googlegroups.com *Use this .* * * *Sub GotoSheet()* *

RE: $$Excel-Macros$$ Solution required

Use this . Sub GotoSheet() Dim StrString As String Dim VarSheetArr Dim wksSheet As Worksheet Dim VarCount VarCount = 1 For Each wksSheet In ThisWorkbook.Worksheets StrString = StrString & VarCount & vbTab & wksSheet.Name & vbCrLf VarC

$$Excel-Macros$$ R-project

Hi All, Sorry, the r-project is not a part of this forum. But i just want to know if somebody might have some idea on this. Any one know about R-project ? if positive please let me know some tips. --Every body have right to know something then nothing !! Thanks & Regards, *Deba ranjan* ***

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012

congrats rajan Regards, Gawli Anil On Fri, Oct 12, 2012 at 11:09 PM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > Congrats rajan for your threshold efforts.. > > > On Wed, Oct 3, 2012 at 2:19 AM, Asa Rossoff wrote: > >> I'm happy to see you recognized and honored for your cont

RE: $$Excel-Macros$$ Automation in excel

Download this book. Excel 2003 Power Programming with VBA By j-walk You can learn from basic to intermediate knowledge of VBA from this book.. every chapter written in a very explanatory way, you will really enjoy reading this book. Regards Rajan verma +91 7838100659 [IM-Gtalk]

$$Excel-Macros$$ Solution required

Dear Members, I wnat one solution for switch between sheet. 1. I am having on file containing 12 sheets and i have to work between the two sheets (sheet 2 & sheet 11) alternatively. If any shorcut key is there to switch between sheets. Sheets are no adjuscent othewise I can use ctrl+page up, down

$$Excel-Macros$$ AUTO: Sharon Hutchison is out of the office (returning 15/10/2012)

I am out of the office until 15/10/2012. Any queries please contact Nicky Minchella Note: This is an automated response to your message "$$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 7 Messages in 5 Topics" sent on 13/10/2012 1:40:12 AM. This is the only notification you will r

RE: $$Excel-Macros$$ Automation in excel

Waiting for reply On Oct 10, 2012 11:52 PM, "Manoj Kumar" wrote: > Actually I don't know about the coding in vba where I can learn coding for > vba. I know only record macro. I want to do coding in my way. What I want > I get it from my data. > > Thanks > Manoj > On Oct 10, 2012 11:20 PM,

Re: $$Excel-Macros$$ How to shrink a picture in userform

Hillary There was no userform in the file. Perhaps because it was an xlsx not xlsm. In a userform a picture has height and width propertir=es which you can amend in the property sheet or in code Regards David Grugeon On 12 October 2012 19:57, Hilary Lomotey wrote: > Hello Experts > > I'd l

Re: $$Excel-Macros$$ Best thing?

Good question Rajan!! Expecting quite a lot of creative answers for this one ! Sent on my BlackBerry® from Vodafone -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Sat, 13 Oct 2012 00:21:15 To: Reply-To: excel-macros@googlegroups.com Subject: $$Exce

$$Excel-Macros$$ Best thing?

What is the best thing you do/Can do with Excel? Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Po

RE: $$Excel-Macros$$ Email address for ms access forum

You can join this group for MS Access and SQL regarding query, although group is recently started but Experts are here to make you expert J https://groups.google.com/group/access-sql?hl=en &pli=1 Regards Rajan verma +91 78381006

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012 *

Nice going Raj, keep it up, On Fri, Oct 12, 2012 at 5:39 PM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (rajasekhar.prahar...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012

Congrats rajan for your threshold efforts.. On Wed, Oct 3, 2012 at 2:19 AM, Asa Rossoff wrote: > I'm happy to see you recognized and honored for your continued great > contribution Rajan. > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.co

$$Excel-Macros$$ Re: Using Excel macro to type custom function in cell ...

Thank you! This works and is just what I needed. :-) Regards, Greg On Thursday, October 11, 2012 7:21:21 AM UTC-4, Prince wrote: > > Hi Gerg > > Just copy paste this macro and run it. > > sub test() > with ActiveSheet > .range("AP2").Formula= "=Switch(Y2,""B"",""H"",NOT(AH2),""O

Re: $$Excel-Macros$$ formula to find odd one's out in both the sheets

Hi Rajesh, Find the attachment. -- *Regards,* * * *Excel Beginner* * * On Fri, Oct 12, 2012 at 4:16 PM, Rajesh Agarwal wrote: > Dear Sir > How can i find odd one's in sheet 1 from sheet 2 and sheet 2 from sheet 1. > Rgds > > -- > *Rajesh Kumar Agarwal* > > -- > Join official f

RE: $$Excel-Macros$$

What?? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Harkesh Kumar Sent: 12 October 2012 2:45 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ -- Join official facebook page of t

RE: $$Excel-Macros$$ Email address for ms access forum

access-...@googlegroups.com Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of santosh subudhi Sent: 12 October 2012 3:15 To: excel-macros Subject: $$Excel-Macros$$ Email address for ms access forum

Re: $$Excel-Macros$$ formual to separate data from a cell

PFA... On Fri, Oct 12, 2012 at 5:24 PM, Munshi, Anwar wrote: > Hi, > > ** ** > > How can I separate data in a cell with no space, comma etc.? I have > attached file for reference > > ** ** > > ** ** > > Regards > *Anwar* > > > > ** ** > > -- > Join official facebook page of this f

Re: $$Excel-Macros$$ formula to find odd one's out in both the sheets

Hi Rajesh, You can use Offset function. Regards, Kuldeep Singh On Fri, Oct 12, 2012 at 4:16 PM, Rajesh Agarwal wrote: > Dear Sir > How can i find odd one's in sheet 1 from sheet 2 and sheet 2 from sheet 1. > Rgds > > -- > *Rajesh Kumar Agarwal* > > -- > Join official facebook page of this for

$$Excel-Macros$$ formual to separate data from a cell

Hi, How can I separate data in a cell with no space, comma etc.? I have attached file for reference Regards Anwar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread t

Re: $$Excel-Macros$$ How to shrink a picture in userform * *

you are welcome !! Thanks & Regards, *Deba ranjan* On Fri, Oct 12, 2012 at 4:21 PM, Hilary Lomotey wrote: > excellent Deba, it works. thanks > > On Fri, Oct 12, 2012 at 10:40 AM, Deba Ranjan wrote: > >> [image: Boxbe] This message is >> eligible for A

Re: $$Excel-Macros$$ How to shrink a picture in userform * *

excellent Deba, it works. thanks On Fri, Oct 12, 2012 at 10:40 AM, Deba Ranjan wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (drdeva...@gmail.com) Add cleanup > rule

$$Excel-Macros$$ formula to find odd one's out in both the sheets

Dear Sir How can i find odd one's in sheet 1 from sheet 2 and sheet 2 from sheet 1. Rgds -- *Rajesh Kumar Agarwal* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread tit

Re: $$Excel-Macros$$ How to shrink a picture in userform *

Hi Hilary, After Inserting the Pic in the Userform, you need to go to the properties, and Select the -PictureSizeMode as 1. you can see the pic full. Thanks & Regards, *Deba ranjan * On Fri, Oct 12, 2012 at 4:03 PM, Hilary Lomotey wrote: > i have inserted a picture in a use

Re: $$Excel-Macros$$ How to shrink a picture in userform *

i have inserted a picture in a user form in the attached, however, i cant see the whole picture in the userform only a minute portion, i need assistance to shrink the picture in the userform to fit. in the excel sheet itself i placed a picture there to give you an idea of the size that i want it to

Re: $$Excel-Macros$$ Re: pls subcribe me ASAP

*Dear Anil* *you are already subscribed on this forum.* *And the same thing was informed by Noorain yesterday..* * * *Regards* *Pravin Gunjal* On Fri, Oct 12, 2012 at 2:20 PM, अनिल नारायण गवली wrote: > Dear Groups, > > Pl ssubcribe me .. > > Thanks & Regards, > Gawli Anil > > On Thu, Oct 11,

$$Excel-Macros$$ How to shrink a picture in userform

Hello Experts I'd like you to please help me in reducing both the height & width of the picture (ie .- Go to VBA environment and open the userform )so that the pic. overall size will appear smaller if the userform is activated such as the one in the excel sheet itself. thanks -- Join official

$$Excel-Macros$$ Email address for ms access forum

Hello Group, Do we have any group for MS access like this forum for excel. If so plz provide me the email address of the forum. -- Regards Santosh santoshkumar.subu...@gmail.com -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members a

Re: $$Excel-Macros$$

What's your query Mr. Harkesh. Regards, Kuldeep Singh On Fri, Oct 12, 2012 at 2:45 PM, Harkesh Kumar wrote: > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thre

$$Excel-Macros$$

-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will n

$$Excel-Macros$$ Re: pls subcribe me ASAP

Dear Groups, Pl ssubcribe me .. Thanks & Regards, Gawli Anil On Thu, Oct 11, 2012 at 12:24 PM, अनिल नारायण गवली wrote: > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > -- Thanks & Regards, Gawli Anil Narayan Software Developer,