$$Excel-Macros$$ Excel VBA macro to filter and delete duplicate rows

astCol = .Cells.Find(What:="*", After:=.Range("A1"), LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column 'Set up an index column of ascending numbers after the last column .Cells(1, lLastCol + 1).Value = 1 .Ran

$$Excel-Macros$$ Help with column function

Hi Everyone, I am a newbie. Please be patient with me. OK. Here is what I want to do. I have a bunch of small macros that use the following code. The only difference when the code runs in the different small submacros is that in the statement: Range("C" & CStr(LCurSRow)).F

$$Excel-Macros$$ Excel Macro to display correct month

Hi Everyone, I am a begineer with VBA. I need some help. Sample data is shown below. Column A is a list of employee names. The TBD person represents a new hire that will be hired sometime in the future. Columns AR and beyond are months years. For example, row 1 column AR is Sept -09. Row 1

$$Excel-Macros$$ Excel VBA macro to filter and delete duplicate row (Part 2)

A6. Usage: FilterDelete (ActiveSheet.Range("A6")) SAMPLE DATA BEFORE Column A Column BColumn C Employee1 ProjectName1 10 Employee1 ProgramName2 20 Emplyee2 ProjectName35 Emplyee2 ProjectName10 50 Emplyee4 Projec

$$Excel-Macros$$ Help with quotes in COUNTIF formula

t writing the same formula above for a macro. Seems to be a problem with the quotes. Not sure what the problem is. Can someone help me? THanks. Range("C" & CStr(LCurSRow)).Formula = "=COUNTIF("Dept!AR&qu

$$Excel-Macros$$ Complicated nested IF inside cell formula macro

Hi Everyone, I'm having troubles with this formula. It currently works. But I would like to extend the range out to column CE. There are 2 problems: 1). I would like to wrap the text of this formula so that it appears as 4 lines in the vba editor. It's too hard to read as 1 gigantic line.

$$Excel-Macros$$ Need to add sort by column A, G, and J to this macro

Hi Everyone, Thanks for your help. I am a newbie, but I have learned alot in the past couple of weeks. This is the problem. I have a spreadsheet of employee names and projects with durations in months. Now, I would like to delete the employees that are supporting multiple projects and only kee

$$Excel-Macros$$ Help with CountIf in Macro

Hi Everyone, Need some help with this macro. Basically, I am searching through rows and looking for any values in the cells that are >0 in columns AR - CE. After I find these cells in that range, I need to count the number of columns. This can be done with the COUNTIF function. I also do not w

$$Excel-Macros$$ excel vba macro to populate listbox

like to subtract the month number value from a column in B and display the result in column C. For example, List Box = March 10 List Month value = 3 Column A Column B Column C EmployeeCurrent Assignment (Months Rema

$$Excel-Macros$$ Query Question with Excel Stock File

I am working on creating an Excel file that will pull data from barcharts.com for stocks listed in this Excel file and what I'm trying to have it do is automatically show if it's a "sell", "strong sell", "buy", "strong buy", "weak buy", etc. and then either say that like it already does in colu

$$Excel-Macros$$ Re: Query Question with Excel Stock File

*I forget to attach the file which I'm doing now.* On Saturday, February 15, 2020 at 3:04:56 PM UTC-5, Mike C. wrote: > > I am working on creating an Excel file that will pull data from > barcharts.com for stocks listed in this Excel file and what I'm trying to > have

$$Excel-Macros$$ Industrial Security Systems in Bangalore

*Industrial Security Systems in Bangalore* Security and police investigation Services AFL offers end-to-end security system solutions together with securitystyle and consulting, product management, remote observation and support and maintenance http://www.busybizz.com/security-systems-bangal

$$Excel-Macros$$ Unable to use a user defined fintion in a sql statement connecting to a worksheet

Hi, while I do have experience in vba Access I am new in writing VBA for excel. In access one can write and call public UDF in a sql statement. Is it possible to do so in Excel. I wrote a the UDF calcT1redemption which I have tested and works but when I call it from the sql statement below it s

$$Excel-Macros$$ Macro to export Table Titles/Headers AND the contents of each table from Word to Excel

I am looking for a Macro to export the contents of every table in a Word document(s) and move this content to Excel. Along with pulling the contents of the tables however, I would like the titles of each of these tables to be exported as well. The Word document(s) are formatted in a table of

$$Excel-Macros$$ Need VBA for repeating copy and paste special

Hi everybody - I am hoping someone may be able to help me out. I am still quite a novice with writing VBA, so I am sure there is an easy way to make what I am trying to do. I am working in Excel 2010. I have a spreadsheet with a tab that has data vertically from column A through column ZW. I am

Re: $$Excel-Macros$$ Need VBA for repeating copy and paste special

).Copy > Sheet1.Range(Cells(1, i), Cells(LR, i)).Copy > Sheet2.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial > Paste:=xlValues, Transpose:=True > Next > End Sub > > HTH > Mahesh > > > > On Thu, Mar 8, 2012 at 8:54 PM, Erick C wrote: > > Hi

Re: $$Excel-Macros$$ Need VBA for repeating copy and paste special

Hi Kris - Thank you for the reply, I tried out your code and it works perfectly! Thank you all again for your responses! On Mar 9, 12:18 am, Kris wrote: > > Hi > > Try this > > Sub kTest() > >     Dim wksFrom     As Worksheet >     Dim wksTo       As Worksheet >     Dim i           As Long >

$$Excel-Macros$$ Need help with code to automate copy/paste

Hi everybody! I am hoping someone may be able to jelp me out. I am trying to write a macro that will take a formula that i write and copy it, move to the right seven spaces, paste, move seven spaces again, paste, ect.. Right now I need to have the formula pasted all of the way through column AZZ.

Re: $$Excel-Macros$$ Need help with code to automate copy/paste

Hi Ashish, Thank you, your suggestion works perfectly! Thanls again for the prompt response! -- FORUM RULES (986+ 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 Advic

excel-macros@googlegroups.com

Dear All, I want to Export data to Excel 2007 from SQL Server 2000 table.Kindly help on this. -- *Regards,* *Venkat* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : h

excel-macros@googlegroups.com

any clarification on the same. > > > > On Sat, Feb 19, 2011 at 2:59 AM, Venkatesan c wrote: > >> Dear All, >> >> I want to Export data to Excel 2007 from SQL Server 2000 tab

excel-macros@googlegroups.com

Thank U On Mon, Feb 21, 2011 at 12:35 PM, saggi wrote: > Just Go on DATA ribbon in Xl, Then Other Sources, then Give the path > of SQL table this exercise need to done once. > > after onward same u can pull from Existing Connection just need to > given Username & Password. > > Regards >

$$Excel-Macros$$ SQL Server Group

Dear All, I want SQL Server Group something like our excel-macros group. Can anyone send me the links.. Thanks in Advance.. *Best Regards,* *Venkat* -- -- Some important links for excel users: 1. Follow us on TWIT

Re: $$Excel-Macros$$ Index, Match, Vlookup Memory Cards [Free downloads]

Dear Ayush, Thank for good share of tutorial Regards, Venkat On Fri, Jun 10, 2011 at 10:13 PM, Ayush wrote: > Well, he's done it again. My good friend John Franco just uploaded these free > lookup syntax mastery > downloadsfor you. > To be hones

$$Excel-Macros$$ Excel Tips&Tricks Video's Link...

Dear All, Please watch below link in YouTube you may get hundreds of Excel Tips &Tricks... With Excel Sample Excel Workbooks Also [image: image.png] *http://www.youtube.com/user/ExcelIsFun?blend=1&ob=5* * * *Best Regards,* *Venkat* -- -

Re: $$Excel-Macros$$ how to put password in vba coding.??

Hi Kannan, Please go to Module--->VBA Project Properties--->Protection--->Give Password The above way is to protect VBA Project... *Best Regards,* *Venkat* On Wed, Jun 15, 2011 at 2:09 PM, kannan excel wrote: > Hi Guru... > > how to put password in vba coding.?? > > how to protect that? > >

Re: $$Excel-Macros$$ excel query

Hi Azeema, Send the sample data and some one will assist the query.. Best Regards, Venkat.. On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote: > I have a table in excel of # of employees by age, sex and category of > employment. The ROWs have three diff categories by sex and the COLU

Re: $$Excel-Macros$$ Beginer to Excel-VBA

Dear Hari, Just watch the below link video's you may get Some of basics in Excel VBA http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb Best Regards, Venkat On Thu, Jun 16, 2011 at 8:35 PM, Hari wrote: > > Dear Friends, >Can any one please help me in *"how to learn Excel-VBA"*

Re: $$Excel-Macros$$ Pad zeros

Hi Skanda, Please use Below formula for our query. =REPT(0,(9-LEN(B4)))&B4 *Best Regards,* *Venkat* On Fri, Jun 17, 2011 at 3:46 AM, Skanda wrote: > Hi, > How to add zeros in front of a value with varying lengths so that the > length of the column is 9? > for instance a column policy id has

Re: $$Excel-Macros$$ Beginer to Excel-VBA

On Fri, Jun 17, 2011 at 6:00 AM, Venkatesan c wrote: > Dear Hari, > > Just watch the below link video's you may get Some of basics in Excel VBA > > http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb > > Best Regards, > > Venkat > > > On

Re: $$Excel-Macros$$ How to record a macro

Dear Ritesh, Watch Below Link http://www.youtube.com/watch?v=KKJj78LoFaA On Sat, Jun 18, 2011 at 8:20 PM, Susan wrote: > http://www.excel-vba-easy.com/ > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Ritesh Jain > S

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hari, Find attached *Best Regards,* *Venkat* * * *Join My Group: http://groups.google.com/group/excel-miracle * On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR wrote: > I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE

$$Excel-Macros$$ Call Center Inbound&Outbound Manpower scheduling

Dear All, Can any one have templates or websites for Call Center Inbound&Outbound Manpower scheduling. -- *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

Re: $$Excel-Macros$$ Help on Percentile Function

Dear Prashant, Please look below links... http://www.techonthenet.com/excel/formulas/percentile.php http://office.microsoft.com/en-us/excel-help/percentile-HP005209211.aspx *Best Regards,* *Venkat* * * On Mon, Jun 20, 2011 at 6:16 PM, Prashant wrote: > Dear Experts, > > ** ** > > Need he

Re: $$Excel-Macros$$ HaPpY BirthdaY - Sir Paul Schreiner

* Dear Paul, ** Happy Birthday Wishes to you * -- *Best Regards,* *Venkat* * * On Mon, Jun 27, 2011 at 8:30 AM, OpenExcel.com <26may.1...@gmail.com> wrote: > Wish you many many Happy Returns of the Day :) Enjoy :) > > HappY BirthdaY :) > > > Best Regards > Ashish Jain > eXceLiTems

$$Excel-Macros$$ Unprotect Sheet in Excel 2007

Dear All, I want any VBA code or some tool to Unprotect Sheet in Excel 2007 I forgot the password.. *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tri

Re: $$Excel-Macros$$ Unprotect Sheet in Excel 2007

aR1C1 = Chr(i) & Chr(j) & _ > Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _ > Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n) >Exit Sub > End If > Next: Next: Next: Next: Next: Next > Next: Next: Next:

Re: $$Excel-Macros$$ Single Pivot from More than one worksheet

gt; > Thanks !! > > On Tue, Jun 28, 2011 at 11:58 AM, Venkatesan c wrote: > >> Hi Deepak, >> >> Find attached html file .for your queryYou prepare single pivot from >> more than one.data >> >> *Best Regards,* >> *Venkat* >> On Tue, J

Re: $$Excel-Macros$$ Unprotect Sheet in Excel 2007

> On Tue, Jun 28, 2011 at 3:38 PM, SANJAY SONI > wrote: > >> Dear Venkar, >> >> I think the attached file can resolve your problem..It will remove your >> passward. >> >> * >> Best Regards, >> * >> *Sanjay ** >> * >&

Re: $$Excel-Macros$$ How To Concatenate the Cell without loosing the format

Hi Ak, Find attached your query resolved *Best Regards,* *Venkat* On Thu, Jun 30, 2011 at 1:10 AM, Monu Tiwari wrote: > Hi Experts, > > > > I want to concatenate the different cells without losing the format of the > cells. Please refer the excel sheet for more details. > > Thanking you

Re: $$Excel-Macros$$ I want to learn VBA

Hi Pooja, Just watch the below link Youtube video's you may get VBA Basic&Advancedconcepts *Best Regards,* *Venkat* * * On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma wrote: > Hi All, > > I want to learn VBA, therefore, could anybody suggest with a good link > where I can learn it. > > -- >

Fwd: $$Excel-Macros$$ I want to learn VBA

Hi Pooja, Just watch the below link Youtube video's you may get VBA Basic&Advancedconcepts http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb *Best Regards,* *Venkat* * * On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma wrote: > Hi All, > > I want to learn VBA, therefore, could an

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

*Dear Asish,* * * *Congrats...* * * *Best Regards,* *Venkat* * * On Fri, Jul 1, 2011 at 9:25 PM, Ayush wrote: > Dear Group, > I am extremely happy to share a good news with you. One of our dearest > group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for > his exceptional M

Re: $$Excel-Macros$$ I want to learn VBA

is getting a book > dedicated > >>>>> on vba...becoz they provide step wise and detailed concepts > >>>>> there are many free ebooks on vba on the internet.download it > >>>>> ...learn basic from there ...and then make reference from

Re: $$Excel-Macros$$ Sumif across multiple worksheets

gt; Nesting can be an issue if you use more references here. > > > > Let me know if this works. > > > > Thanks, > > DILIPandey > > > > On 7/1/11, Susan 1 wrote: > > > > > > > > > > > > > > > > > > > >

Re: $$Excel-Macros$$ Assistance required

Hi Vikas, Look the Below Link http://excelvbatutor.com/vba_tutorial.html *Best Regards,* *Venkat* * * On Sun, Jul 3, 2011 at 3:39 PM, vikas verma wrote: > > Hi All, > > I am good with excel 2007 now I want to learn VBA coding in order to create > automation tool. Please suggest some ideas

Re: $$Excel-Macros$$ count unique values

Hi, Attach Some data ..and send will try.. *Best Regards,* *Venkat* * * On Mon, Jul 4, 2011 at 3:47 PM, airen wrote: > Hi, > i want to count unique values in a selection. I got this formula on > net =SUMPRODUCT((B2:B30<>"")/COUNTIF(B2:B30,B2:B30&"")) but i dont > know how it works. So pl

Re: $$Excel-Macros$$ Recovery plz

Hi just install the software and just open that software and click Remove Password...Before that you have to open Locked VBA Book.. -- *Best Regards,* *Venkat* * * On Mon, Jul 4, 2011 at 6:32 PM, Chandra Shekar wrote: > How to use this software? > > Thanks, > > Chandra Shekar B > > On Fri, D

Re: $$Excel-Macros$$ copy data without opening file

Hi, Just Try Copy &Paste it will work... *Best Regards,* *Venkat* * * On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde wrote: > Hi friends, > > is there any way where we can copy data from closed workbook "A" and paste > it > into workbook "B" which is open? > > -- > > -

Re: $$Excel-Macros$$ workbook location on status bar

Pascal, Yes you are right I have said for 2007 &2010 Version... *Best Regards,* *Venkat* * * On Tue, Jul 5, 2011 at 4:05 AM, netuser501 wrote: > thanx, > > Venkat solution is most practical for 2007 since it works on all > workbooks that work and don't work with vba code. > I guess the

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

Congrats *Ashish,* * * * * -- *Best Regards,* *Venkat* * * On Tue, Jul 5, 2011 at 10:59 AM, Kal xcel wrote: > Congratulation Ashish...You deserve it > > Kalyan > > > On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal wrote: > >> [image: >> http://tracking.technodesignip.com/?action=c

Re: $$Excel-Macros$$ Vlookup Regarding Query Please Help

Hi Jai, Look Attached below.. On Wed, Jul 6, 2011 at 2:19 PM, Jai wrote: > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailyti

$$Excel-Macros$$ Regression Analysis in Excel

Dear All, Can any one help me on Regression Analysis in Excel with sample data.. *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : htt

Re: $$Excel-Macros$$ Regression Analysis in Excel

ykes_.Regression.pdf > http://en.wikipedia.org/wiki/Regression_analysis > > http://office.microsoft.com/en-us/excel-help/perform-a-regression-analysis-HA00963.aspx > > > > On Thu, Jul 14, 2011 at 2:49 PM, Venkatesan c wrote: > >> Dear All, >> Can any one help me on R

Re: $$Excel-Macros$$ Need Formula

Hi Rahim, Look attached file . *Best Regards,* *Venkat* On Thu, Jul 14, 2011 at 10:35 PM, Rahim Sharieff wrote: > Hi Experts, > > Please refer the attached workbook. > > The first sheet here "Schedule" gives the training requirements and > Training batches, and the second sheet "Trainin

Re: $$Excel-Macros$$ MS Access

Hi Siva, You Can Post your MS Access Query's in this group it self... * * *Best Regards,* *Venkat* On Sun, Jul 17, 2011 at 12:13 PM, Siva Sankarnath S wrote: > Hi Smarts, > > Good day.. > > Could you send me googlegroup id for MS Access.. > > -- > Thanks > Siva > > -- > > --

Re: $$Excel-Macros$$ Simple Code

Hi sharad, look attached..it may Help you... -- *Best Regards,* *Venkat* * * On Sun, Jul 17, 2011 at 5:22 PM, sharad jain wrote: > Hi Guys, > > Can someone please send me a simple code for round off to nearest 10? (No > macro if possible.) > > For example, if I put 23 in A1, it should result

Re: $$Excel-Macros$$ Re: Check Boxs on Document

Please Attach There is No Attachment... *Best Regards,* *Venkat* * * On Mon, Jul 18, 2011 at 11:48 AM, Rsh wrote: > Please help me in reducing the code in the attachment above.. > > Thnx in advance > > -- > > -- >

$$Excel-Macros$$ Job

From:""iGATE Global Solutions""< supreet.sa...@igatepatni.com > Date: 18 Jul 11 20:41:03 Subject: iGate Patni hiring Senior Team Leads for WFM-Forecasting_Bangalore location To: Job Location: Bengaluru/Bangalore Dear Candidate, We have few openings in BPO division.Please find details: Work lo

Re: $$Excel-Macros$$ Speedo Meter Chart

Hi , Please Look below Link http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm *Best Regards,* *Venkat* On Tue, Jul 19, 2011 at 11:36 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > Any suggestion please. > > On Mon, Jul 18, 2011 at 2:31 P

Re: $$Excel-Macros$$ Books

Hi, Check The Below link http://www.mrexcel.com/articles.shtml#Charts -- *Best Regards,* *Venkat* * * On Tue, Jul 19, 2011 at 11:37 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hi, > > I need a book about graphs/charts only. Thanks! > > On Wed, Jul 13, 2011 at 7:15 PM, Vikas Chou

$$Excel-Macros$$ Login Logout Report Help Required...

Dear All, I Have attached data sheet with Login Logout timings..i want how much time they were in work...Pure Login hrs have tried one formula...it's working for first 2 Employess not working for all... Please suggest any formula or VBA code... Example: Data: User Name Status Login & Lo

Re: $$Excel-Macros$$ Change e-mail settings

Hi, Just Go to Below link and sign in your Gmail account..and set as a https://groups.google.com/group/excel-macros/subscribe?hl=en and go to Edit my membership --->Email *(Approximately 15 emails per day)*Send each message to me as it arrives and save it... -- *Best Regards,* *Venkat* * * O

Re: $$Excel-Macros$$ Urgent Help needed-Dashboards

Hi Avinash, Try below Links, http://www.l3analytics.com/2011/05/16/free-excel-dashboard-template/ http://www.excelcharts.com/blog/how-to-create-an-excel-dashboard/ http://www.contextures.com/excel-dashboards.html http://www.mrdashboard.com/download.html -- *Best Regards,* *Venkat* * * On Thu,

Re: $$Excel-Macros$$ Login Logout Report Help Required...

It's Working Daniel ...Thanks a lot. *Best Regards,* *Venkat* On Sat, Jul 23, 2011 at 8:19 PM, Daniel wrote: > Hi, > > ** ** > > Run the following macro : > > ** ** > > Sub LoginLogout() > > Dim c As Range > >

$$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

Dear All, I have attached sheet contains my query on Data Validation - Create a drop down list containing only unique -- *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on

$$Excel-Macros$$ Need Help With an Imput Box in VBA

Any help I can get would be greatly appreciated. Thanks! Erick C. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Link

$$Excel-Macros$$ Re: Run Excel Macro?

first suggestion, create two instances of excel. have one do your macros, the other you can use freely. maybe your concern is not with excel, but the weight of your SQL queries. if you're aggregating a large amount of data, the time it takes your DB server to process the query will freeze your

$$Excel-Macros$$ Can macro be made to automate Text-To-Columns?

Hello everybody- I have a problem that I am hoping someone may be able to help me out with. I have some system-generated reports that I would like to use in Excel, but they are formatted for PDF viewing. Currently, I go in and use Text-To-Columns to split up the columns, but this is a bit tedious

$$Excel-Macros$$ Excel Macros Free PDF

Dear All Can I Have Excel Macros PDF Complete Guide -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video a

$$Excel-Macros$$ Excel Macros Free PDF

Can I Have Excel Macros PDF Complete Guide -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text),

$$Excel-Macros$$ How to Convert Time to Sec

8:59:44 into Decemical seconds is there any formula anyone help me Thanks & Regards Venkat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

$$Excel-Macros$$ Excel Formula Required

Dear All, Any one can Assist me attached file query It's something like reverse Lookup -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

$$Excel-Macros$$ which one is my active sheet?

Hello, I have the following problem: Workbooks(datei).Sheets(land).Activate Range("A1:Z176").Copy Workbooks(hier).Activate Sheets(land).Activate ActiveSheet.Paste Workbooks(datei).Activate ActiveWorkbook.Close

$$Excel-Macros$$ Re: Sub not visible

I doubt whether you have defined the Sub procedure as Private. If so remove the Private key word. C.Saravanan On Thu, Nov 20, 2008 at 9:16 PM, macrogirl wrote: > > I have a sub procedure written under another procedure. When I press > F5 to run the procedure, it is not listed in the drop down me

$$Excel-Macros$$ Automatically paste contents of active cell into Webpage Search box

Someone gave the the below macro (using Microsoft Internet Controls via Code Editor > Tools > References) for taking the active cell in Excel and then automatically placing it in a search box in a new Explorer Webpage, and then in effect, hitting ENTER. It works with the website provided, www.eba

$$Excel-Macros$$ Re: Automatically paste contents of active cell into Webpage Search box

lia > Microsoft Certified Application (Excel) Specialist > Technical Trainer - Excel and VBA > Author ->www.excelitems.com > +91--40-48-43 > ---­----- > ---­-

$$Excel-Macros$$ Jump to Yahoo Mail with Active Cell Contents, and then perform a search in the Search Mail Box

Hello, I am trying to accomplish the following, in case anyone knows how to do it. I need to (1) take the contents of the active cell, (2) open my yahoo mail in internet explorer(http://us.mc576.mail.yahoo.com/mc/ welcome?.rand=d64n921nnhrdu). And then (3) to place the active cell contents in t

$$Excel-Macros$$ Re: Jump to Yahoo Mail with Active Cell Contents, and then perform a search in the Search Mail Box

--- > Regards > *Ashish **Jain* > Analyst, CSC Australia > Microsoft Certified Application (Excel) Specialist > Technical Trainer - Excel and VBA > Author ->www.excelitems.com > +91--40-48-43 > -------

$$Excel-Macros$$ Jump to Yahoo Mail and perform search with Active Cell Contents - attempt two

Anyone know how I can resolve the error message I am getting.or have similar code that I could try. Hello, I am trying to accomplish the following, in case anyone knows how to do it. I need to (1) take the contents of the active cell, (2) open my yahoo mail in internet explorer(http://us.mc

$$Excel-Macros$$ Unique No

Hello All... A Column in a sheet must have only unique nos... when we enter the same no again it have to give t message NO ALREADY EXIST. pls help to to find it out. Thanking you, Vivek Chandran, Ooty - TN -- --

$$Excel-Macros$$ Help Required

Dear Group, Please help me to create Function for below Problam & Help books,Procedure to create udf's 20100312=12-mar-2010 * Thanks & Regards, Venkat C* -- -- Some important links for excel users:

$$Excel-Macros$$ Fwd: Help Required

Dear Group. Iam the beginner for Excel macros. I want to know what is the procedure to write a macro and kindly provide some examples in excel files *Thanks & Regards,* *Venkat * -- -- Some important links for exce

Re: $$Excel-Macros$$ Fwd: Help Required

ernatively, you can search for "VBA Course for beginners" over internet. > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > &

$$Excel-Macros$$ Fwd: Macro Help Msg Box

Dear Group, Need Assistance for folowing Problam active cell value is Number(or)text(or)Formula Should show as a msg box by using Macro *Thanks & Regards,* *Venkatesan C* -- -- Some important links for e

$$Excel-Macros$$ Help Reqired Multiple conditions Lookup

Dear Group, Any send me with example Multiple conditions Lookup -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN g

$$Excel-Macros$$ Need macro help - Need to sort, cut and paste

Good morning everybody - I am still quite a novice when it comes to VB and writing codes, so any help I can get would be greatly appreciated. I am currently working on a code that takes data from a xls file that I download and convert it to a text file. I found an older posting with an example t

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

> but the values have no spaces or delimiters between them. > > I think I can do the entire process with a single macro: > In my test data, it processed 65,536 records of 74 columns > in 8 minutes, 32 seconds. > '-------

$$Excel-Macros$$ Automation Help required

Dear Group, I have attached here with help required sample data.I had given input &output required in different sheets. please any one create for this VB Code and let me know Best Regards, * Venkat * -- -- Some im

Re: $$Excel-Macros$$ Automation Help required

down. Hope this will help. Please let me know in case you > need my assistance. > > Regards, > > Deepak > > On Sat, May 22, 2010 at 4:21 PM, Venkatesan c wrote: > >> Dear Group, >> >> I have attached here with help required sample data.I had given input >

$$Excel-Macros$$ Lotus Notes scheduled Future mails Help

Dear Group I am using Lotus notes 7. I want send scheduled Future mails is there sending Option else any tolls please send it to me. Best Regards, * Venkat * -- -- Some important links for excel users: 1. Follow

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

Dear Ayush, Good show Best Regards, * Venkat * On Mon, May 24, 2010 at 9:00 AM, Ayush wrote: > Dear Group Members, > > Finally, after long time we have achieved a milestone of 7000 > members. > > I would use this moment to thank each one of you for your contribution > to the group. This gro

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

ot; > to > StrDelim = "" > > it should do what you want. > if you don't NEED to copy the records where T and E are different, you can > comment out that section. > > Paul > > > From: Erick C > To: MS EXCEL AND VB

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

hrough to see what it is doing. > > You should find the problem then. > > sorry for the confusion (and sarcasm) ;) > > Paul > > > From: Erick C > To: MS EXCEL AND VBA MACROS > Sent: Mon, May 24, 2010 3:41:51 PM > Subject: Re: $$E

Re: $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired

; > *Jitendra Kr. Verma** *** > -- > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Venkatesan c > *Sent:* Tuesday, June 01, 2010 3:07 PM > *To:* Google > *Subject:* $$Excel-Macros$$ Excel Sheet Renameing Macro Reqi

Re: $$Excel-Macros$$ Excel Sheet Renameing Macro Reqired

n.Worksheets.Count* > * > * > *Sheets(i).Name = Left(Sheets(i).Name, 3) & mo & Right(Sheets(i).Name, > 3)* > *Next i* > * > * > *End Sub* > > > > Warm Regards, > > Harmeet Singh > > http://www.facebook.com/libraharry > > > >

$$Excel-Macros$$ Formula Help Required Urgent

Dear Group, Can i have UNIQUEIFS Function its some thing like SUMIFS Best Regards, * Venkat * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/e

Re: $$Excel-Macros$$ Formula Help Required Urgent

hread.php?t=312142 > > Regards, > Andy > > On Thu, Jun 3, 2010 at 6:57 PM, Venkatesan c wrote: > >> Dear Group, >> >> >> >> Can i have UNIQUEIFS Function

$$Excel-Macros$$ Help Reqired Loop in macros

Dear Group, What you mean by Loop in Macros&Use .can i have explanation with Example Best Regards, * Venkat * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http:/

$$Excel-Macros$$ Help Required Extract Numbers

Dear Group, Find Below data Requirement.I Want to extract numbers post (_ )Only. Raw Data Required Best Regards, Venkat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

  1   2   >