$$Excel-Macros$$ excel vba

each time i save many spreadsheeets into a folder; i want to set up a macro do this: open each spreadsheet in the folder and then change the print setting in a way the spreadsheet could be printed in one page and then close each spreadsheet. anyone knows how to wrote a macro like this??? thanks a l

$$Excel-Macros$$ EXCEL VBA

Dear All, I am Completely new to VBA.I don't know its terminology and how to write programs to execute specific action in Excel.I want to learn Excel VBA in an easy way.Any E book would be of immense help to me and other people would like to learn VBA.Please upload any VBA material . Regar

$$Excel-Macros$$ Excel vba

hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops in excel VBA I want to learn excel vba , could any one give help me -- Regards, Shivaprasad K. -- Join official facebook page of this forum @ https://www.facebook.com/discussex

$$Excel-Macros$$ Excel & VBA

Hi All, Must visit below mentioned ... Happy New Year 2014 Thanks & regards, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel F

$$Excel-Macros$$ Excel VBA Book?

I don't know VBA other than manipulating recorded macros. What is the quickest way to learn from foundation up? Book? Some pay site? It takes to long to go through youtubes. I would like a info dense book that does not assume prior prior VBA knowledge but also assumes I know what a keyboard is

$$Excel-Macros$$ excel + vba + html

Hello everyone, I am from Brazil and I am developing a document in excel with a lot of vba codes (buttons, combobox, hyperlinks) and it has arount 150sheets (some are hidden, and I only have access to it if I select on a combobox) I am thinking about to post this document on a webpage, but not a

$$Excel-Macros$$ excel vba help

I am trying to teach myself how to use the vba. I want to use a copy/paste and loop macro for some equations. I already know how to use my formulas to automatically calculate but I need help getting info into the right cell. The basics of it goes like this; I want to get a number to copy to the

$$Excel-Macros$$ Excel vba link

Hi Everyone, Please check this link of excel vba http://www.excel-vba-easy.com/vba-basic-msgbox.html Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://tw

$$Excel-Macros$$ EXCEL-VBA Query...

Dear Experts.. We want to transfer *Total Asset* column(F) in another sheet(Database) on daily basis in current date column through *Transfer in Database* Button. Please see attached file.. -- With thanks & regards, Noorain Ansari --

$$Excel-Macros$$ excel vba opening

Hi, Prithvi Information Solutions Ltd is a global provider of enterprise solutions and services that strategically harness the power of Information Technology to help customers maximize their business values in the new economy. Prithvi has offices in USA, Canada, United Kingdom, Singapore, and Indi

Re: $$Excel-Macros$$ excel vba

    '     ' make print area changes here     '     ActiveWorkbook.Close savechanges:=False     End If     Next File End Sub Paul From: Oliver To: MS EXCEL AND VBA MACROS Sent: Thu, February 10, 2011 4:45:21 PM Subject:

Re: $$Excel-Macros$$ EXCEL VBA

Hi Vijay, I would suggest to check the Group's page for ebooks. Alternatively, you can also google and download pdf books as per your choice. There are many online tutorials available as per various expertise levels and may be you can search "Excel VBA tutorials for beginners". Best Regards, DIL

$$Excel-Macros$$ Excel VBA Challenge

Hi Guys, Challenge is to Delete all Sheets Except one without any loop and mapping table. Keep Excelling 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

RE: $$Excel-Macros$$ Excel vba

[mailto:excel-macros@googlegroups.com] On Behalf Of Shiva Prasad Sent: 12 September 2012 6:34 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel vba hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops in excel VBA I want to learn

Re: $$Excel-Macros$$ Excel vba

can.” - John Wesley - From: Shiva Prasad To: excel-macros@googlegroups.com Sent: Wed, September 12, 2012 9:05:01 AM Subject: $$Excel-Macros$$ Excel vba hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops

Re: $$Excel-Macros$$ Excel vba

*- > > > ------ > *From:* Shiva Prasad > *To:* excel-macros@googlegroups.com > *Sent:* Wed, September 12, 2012 9:05:01 AM > *Subject:* $$Excel-Macros$$ Excel vba > > hi team, > > my job profile is mi

$$Excel-Macros$$ Excel VBA Example

Hi Friends, Find attached some examples of VBA Macro *Thanks,* *Nilkanth Raval* *+91 900 428 0 428* *+91 808 000 1620* *Think Before You Print.Consider ENVIRONMENT.* *“SAVE TREES, SAVE EARTH” * *“All appears to change when we change!”* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

$$Excel-Macros$$ Excel VBA/ Access

Hi, I have posted this on the access group too, it can't really be classified as one or the other, but it's driving me mad, can anyone help. I have an Access 2010 database, which I have saved as .mdb. (ie not accdb) It has an update query in, which takes 2 string parameters. When I run it from

$$Excel-Macros$$ Excel-VBA QUIZ

Dear Group, Hope you are doing well. Now You have a new Quiz, Please solve, revert and analyze where you are? Quiz Link is here : Note: You have to write full form of Excel,VBA and MS Access Keywords. Quiz-2

$$Excel-Macros$$ Excel VBA Training

[image: Inline image 1] -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

$$Excel-Macros$$ Excel VBA Password protection

Dear Team Kindly let me know how to protect macro in Excel 2007 I want to lock the VBA so no one can step into it w/o the password -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formul

Re: $$Excel-Macros$$ Excel VBA Book?

Refer functionx.com/vbaexcel this will help Sandeep On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot wrote: > I don't know VBA other than manipulating recorded macros. What is the > quickest way to learn from foundation up? Book? Some pay site? It takes to > long to go through youtubes. > > I woul

Re: $$Excel-Macros$$ Excel VBA Book?

PERFECT!! Thank you very much! I knew there was something out there I haven't found yet. On Tuesday, June 5, 2012 10:57:07 AM UTC-4, Sandeep Kumar Baranwal wrote: > > Refer > functionx.com/vbaexcel > > this will help > > Sandeep > > > On Tue, Jun 5, 2012 at 7:12 AM, charlyRoot wrote: > >> I don

$$Excel-Macros$$ EXCEL / VBA BOOK REQU

Dear All, Pls any bade having the excel /vba books Pls sent to my mail id Kindly do need full Thanking You, Madhu Bangalore HUB Cell : 91-9743130534 This e-mail and any attachments are confidential and intended solely for the addressee and may also be privileged or

$$Excel-Macros$$ Excel vba for outlook

Hi all i am using excel vba to send mails through outlook.. the sample code is as below Set OutApp = CreateObject("Outlook.Application") OutApp.Session.Logon Set OutMail = OutApp.CreateItem(0) ' Application.Wait Now

$$Excel-Macros$$ Excel VBA Password settings!!!

Hello All, I have some of Excel Files with VBA Passwords. If you press "Alt" + "F11" then it goes to VB Window. Then if you click on the VBAProject in that then it immediately gives a message as its password protected but I didn't double click in that. Its just a message. So u cant even double cl

Re: $$Excel-Macros$$ excel vba help

Dear Jason, To do this you do not need the macros Go to edit-> Fill-> Down That will work Sanjoy On Mon, Feb 8, 2010 at 3:24 AM, jason nix wrote: > I am trying to teach myself how to use the vba. I want to use a copy/paste > and loop macro for some equations. I already know how to use my f

RE: $$Excel-Macros$$ excel vba help

(i, 1) will refer to A3, and so on. Hope this helps. Regards - Dave. > Date: Sun, 7 Feb 2010 13:54:22 -0800 > From: opie...@yahoo.com > Subject: $$Excel-Macros$$ excel vba help > To: excel-macros@googlegroups.com > > I am trying to teach myself how to use the vba.

Re: $$Excel-Macros$$ excel vba help

but  still... Paul From: Dave Bonallack To: "excel-macros@googlegroups.com" Sent: Mon, February 8, 2010 9:52:17 PM Subject: RE: $$Excel-Macros$$ excel vba help Hi Jason, One way to increment your cell is to use the "Cells" thingy. Th

RE: $$Excel-Macros$$ excel vba help

Thanks Paul, Always learning. BTW, does 'Cells' do anything that 'Range' can't? Dave. Date: Tue, 9 Feb 2010 05:58:28 -0800 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ excel vba help To: excel-macros@googlegroups.com Dave... Just a bit of

Re: $$Excel-Macros$$ excel vba help

Cells() can do that isn't available in Range() But usually, I just use the one that fits my code. P From: Dave Bonallack To: "excel-macros@googlegroups.com" Sent: Tue, February 9, 2010 9:38:46 PM Subject: RE: $$Excel-Macros$$ excel vba help Thanks P

RE: $$Excel-Macros$$ excel vba help

Ok, thanks Paul. Dave. Date: Tue, 9 Feb 2010 20:11:23 -0800 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ excel vba help To: excel-macros@googlegroups.com Sometimes, Cells() is a bit easier to read. For instance, if you want to cycle through columns A-J and rows 1-100 and

Re: $$Excel-Macros$$ EXCEL-VBA Query...

Here is your code. Regards Vasant On Tue, Jul 27, 2010 at 6:31 PM, NOORAIN ANSARI wrote: > Dear Experts.. > > We want to transfer *Total Asset* column(F) in another sheet(Database) on > daily basis in current date column through *Transfer in Database* Button. > Please see attached file.. > > --

$$Excel-Macros$$ Excel VBA job opening

We are looking for VBA Excel developer for a MNC for their Gurgaon office. Knowledge of SQL would be an advantage. Minimum Exp: 2 years. Send your resume to gauravhpah...@gmail.com latest by 10/8/2010. Salary package would be best in industry. -- --

Re: $$Excel-Macros$$ Excel VBA Challenge

A suggested way to do it in http://www.excelfox.com/forum/f13/delete-worksheets-without-loop-515/ Here's a slightly modified version of the same Sub kTest() Dim var As Variant With Application var = .Transpose(.Evaluate("Row(2:" & Sheets.Count & ")")) .DisplayAlerts = 0

Re: $$Excel-Macros$$ Excel VBA Query

Add a new blank column before A in both the workbooks and use below formula in cell a2 and fill it down IF(B2<>"",B2&C2,LEFT(A1,FIND(C1,A1))&C2) then use simple vlookup to get the status Regards Ashish On Sat, Oct 20, 2012 at 6:14 PM, Manish Bankoti wrote: > Hi, > > Please find attached

Re: $$Excel-Macros$$ Excel VBA Example

Its really good!! Cheers!! On Tue, Mar 3, 2015 at 8:02 AM, Nilkanth Raval wrote: > Hi Friends, > > Find attached some examples of VBA Macro > > *Thanks,* > *Nilkanth Raval* > *+91 900 428 0 428* > *+91 808 000 1620* > *Think Before You Print.Consider ENVIRONMENT.* > *“SAVE TREES, SAVE EARTH” *

$$Excel-Macros$$ Excel VBA interview questions

Dear Experts, Please use below link for excel-vba interview questions.. http://www.coolinterview.com/type.asp?iType=220 Kindly share with group if any one have other links or Excel-VBA Interview questions.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Excel-VBA QUIZ

Hi Noorain, Thanks for arranging Quiz-2. It helps us to analyze where we are.. And now eagerly waiting for result as today is the 5th day of this contest n also waiting to know for how many members takes part in this Quiz contest n whats our score.. And Ashish Sir & other friends here please tak

Re: $$Excel-Macros$$ Excel VBA Training

Hi Send details On Friday, July 28, 2017, Rajan Verma wrote: > > [image: Inline image 1] > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES

Re: $$Excel-Macros$$ Excel VBA Password protection

t u need? > > ** ** > > ** ** > > Regards, > > Muneer, > > CC… > > ** ** > -- > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *PrIyAnKa > *Sent:* Tuesday, March

Re: $$Excel-Macros$$ Excel VBA Password protection

> >> CC… >> >> ** ** >> -- >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *PrIyAnKa >> *Sent:* Tuesday, March 06, 2012 10:30 AM >> *To:* excel-macros@goog

$$Excel-Macros$$ Excel VBA dynamically fill ComboBox?

Hello, I have a question on using VBA to programme several ComboBoxes whose items are dynamically filled? I have a worksheet containing country names, states, and product, such as CountryState Product 1 US MA Banana 2 US MA Orang

Re: $$Excel-Macros$$ Excel VBA : Unique Values

Dear Sundar, There are two things - First - If you want to put all unique values (the existing ones and the newly added) in those 3 columns and are ready to hit Update button every time then add the following two lines in the beginning of your code - *Range("N5:P65000").Select Selection.ClearCo

Re: $$Excel-Macros$$ Excel VBA : Unique Values

Sundar, I don't understand "what is my idea". I told you two different options. Does the first option not help you ? Have you tried adding those 2 lines in your code ? I mean that's what you asked at the first place. The code was giving an error upon running second time because the cells were not

Re: $$Excel-Macros$$ Excel VBA : Unique Values

Hi Abhishek, Please help to proceed with ur idea. Thanks, Sundarvelan On Fri, Aug 6, 2010 at 1:27 PM, Abhishek Jain wrote: > Dear Sundar, > > There are two things - > > First - > > If you want to put all unique values (the existing ones and the newly > added) in those 3 columns and are ready to

Re: $$Excel-Macros$$ Excel VBA : Unique Values

Just use Pivot table. Regards, Kishan Reddy, K On Aug 6, 4:29 pm, Sundarvelan N wrote: > Hi Abhishek, > > Could you help in one more task also. > > That is under each Team leader i need to have corresponding agents name. > > Please help. > > Thanks > Sundarvelan > > > > > > On Fri, Aug 6, 2010

Re: $$Excel-Macros$$ Excel VBA : Unique Values

Sundarvelan, Uploaded a file in http://groups.google.com/group/excel-macros/files with Team+List_Home.xls name. This will add new name automatically when you add name in your data. Does any one help me? I am not getting option to upload file in post? How & From where I can upload in post directly?

RE: $$Excel-Macros$$ Excel VBA : Unique Values

Hi Sundarvelan, I don't know how to do this without VBA because of the duplicates, sorry. Regards - Dave. Date: Mon, 9 Aug 2010 22:58:21 +0530 Subject: Re: $$Excel-Macros$$ Excel VBA : Unique Values From: nsund...@gmail.com To: excel-macros@googlegroups.com Thank you So much!!!

Re: $$Excel-Macros$$ Excel VBA for BOM

hi can you explain it in detail On Fri, Jul 1, 2011 at 11:44 AM, Rash wrote: > Hi I am using the attached bill of material. I need to search the whole > sheet to find unique product numbers. Explained in more detail in the > attached .docx file. > > Attached .xls is my excel file in which i nee

Re: $$Excel-Macros$$ Excel VBA for BOM

Hi, FYI, Sorry, the previously attached file already contains the macro, but its not full proof. It is not highlighting rows 137 to 142. because its not in sorted order. Rash -- -- Some important links for excel u

RE: $$Excel-Macros$$ Excel VBA for BOM

What help do you need in this macro?? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rash Sent: Monday, July 04, 2011 10:25 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel VBA for BOM Hi, With some more detailed explanation

$$Excel-Macros$$ Excel VBA - Alex Cantu contact

Hi ou Anyone have a contact for Alex Cantu re his 'smiley face' vba on Youtube Charles -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use conci

$$Excel-Macros$$ Excel & VBA Jobs (US only)

Hi, Please check and bookmark this link for MS Excel, Access & VBA Jobs. http://jobs.openexcel.com *Best Regards* *Photographer**, Odd Lens Blogger, eXceLiTems.com Traveler, MastWeekend.com Developer, OpenExceL.com (Excel Add-in

Re: $$Excel-Macros$$ Excel VBA interview questions

Awesome! Thanks :) On Wed, Jan 11, 2012 at 11:15 PM, NOORAIN ANSARI wrote: > FYI > > > On Wed, Jan 11, 2012 at 11:04 PM, NOORAIN ANSARI > wrote: > >> Dear Experts, >> >> Please use below link for excel-vba interview questions.. >> >> http://www.coolinterview.com/type.asp?iType=220 >> >> Kindly s

$$Excel-Macros$$ Excel VBA Sharepoint checkout-checkin

I've Googled extensively and tested multiple options for more than 30 hours over the last couple of weeks. The results of my searches all LOOK reasonable, but all have failed to function properly. I have some SUSPICIONS as to why it's not working, but that doesn't lead me to solutions. Here's m

$$Excel-Macros$$ Excel VBA data transfer to Website

Dear Experts: Do you know if Excel VBA has the capability to automate the transfer of data from a spreadsheet to a website (a web based database)? I have heard that Excel's API may be able to do it. Is that so? Thank you!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b

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

Hi, Please be patient. I am a newbie. 1). I would like to populate a listbox with a list of 24 months starting with the current month. Need some help. I'd like to do something where I get the month date of the current month. And have a for loop for the next 24 months. 2). Next, I would like t

$$Excel-Macros$$ Excel VBA Code for Zip Password

Hi Experts Kindly provide me a code for Zip file with password Protection. Q. How to Zip the folders with password in excel vba. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point |

$$Excel-Macros$$ Excel VBA Project in Google Docs

Hello friends, Let's say I have an Excel File with VBA and an a Form that is used to make entries in sheet. Is there a way I can make a Google Doc of it keeping the Form and all the VBA? I searched and found that Google docs do not support VBA but Java Scripts. Can someone share a way forward? On

$$Excel-Macros$$ Excel VBA Vlookup row and column variables

I am trying to do a vlookup on my Excel spreadsheet using the following VBA code: Dim row As Integer Dim prodCodeCol As String Dim weightCol As String row = 2 prodCodeCol = "O" weightCol = "J" Range(weightCol & row).Select ActiveCell.FormulaR1C1 = "=VLOOKUP(" & prodCodeCol & row & ",'[Kogan WMS

$$Excel-Macros$$ Excel VBA Training By Subject matter Experts

Medha Information research Offering In House, Online and Corporate training on Excel VBA Course Highlights Fully handson Sessions. Realtime examples Interview/project support Indepth and exclusive coverage on each topic For More details, Contact us at +91 9945207350 or write us at i...@medha

$$Excel-Macros$$ excel VBA solution - offered at reasonable price

Does any one need help in Excel VBA project or may be entire project to be completed? Let me know. You will get the solution at a reasonable price whether u in US or in India. I am in US right now. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW

$$Excel-Macros$$ Excel/VBA programmer-Midtown Manhattan (Hottest Position)

** * * * Hi Friends, Hope you are doing well today. Please find the job description below and send me the updated resume at ASAP. Here is an Immediate interview for the position. (Please send resumes to vi...@addonusa.com) Name: Contact: E-Mail: Location: Re-Location: Visa: Ava

$$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

Hi, I am testing this fairly simple code for some other purposes but I always get the value 8 regardless of value in A1: Sub testPogoja() If IsEmpty("A1") Then Exit Sub Else Range("B5").Value = 8 End If End Sub -

Re: $$Excel-Macros$$ Excel VBA Project in Google Docs

Friends,...any update? On Sat, Sep 7, 2013 at 11:21 AM, Abhishek Jain wrote: > Hello friends, > > Let's say I have an Excel File with VBA and an a Form that is used to make > entries in sheet. Is there a way I can make a Google Doc of it keeping the > Form and all the VBA? I searched and found t

$$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Dear Group Members, Good news for all of you !! Now you can download VBA macros ebook worth $45 for free. Here is the link to download :- http://recordexcelmacro.com/discussexcel.html I have talked to John Franco (Author) to get this eBook for our group. Please do not miss the chance to downloa

$$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Fantastic - Liked it !! Really helpful :) Thanks & Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com ___

Re: $$Excel-Macros$$ Excel VBA Training By Subject matter Experts

Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. Rule # 05 On 7/2/12, harshita desu wrote: > Medha Information research Offering In House, Online and Corporate > training on Excel VBA > > Course Highlights > > Fully handson Sessions. > > Realtime exa

$$Excel-Macros$$ Excel VBA: String manipulation and tally (Help Needed)

Dear Excel Experts, I could really use your help. I am trying to take a string and with VBA code tally the number of instances of a word and then output into an excel sheet. For example, String >> "People: Tom Hanks(Actor), Michael Jordan(Businessman, Athlete), Fred Astaire (Dancer), Donald

Re: $$Excel-Macros$$ excel VBA solution - offered at reasonable price

Excel VBA training needed online. Do you provide such services? On 28 Jul 2014 02:41, "Sara Lee" wrote: > Does any one need help in Excel VBA project or may be entire project to > be completed? > > Let me know. You will get the solution at a reasonable price whether u in > US or in India. > > I

$$Excel-Macros$$ Excel VBA Programming FOR Dummies 1st EDITION 2010

Dear Team You have ebook Excel VBA Programming FOR Dummies 1st EDITION 2010, Please send soft copy Thanks, Prabhakar Thakur New Delhi +919953736776 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ ht

$$Excel-Macros$$ Excel VBA professional needed for a Project Work

Dear Excel Gurus, I am free lance data analyst, I have set of excel templates to calculate the Savings and Overcharges. I would like to auto-maize the whole process using VBA and Macro. I would like to know the professional who can create the package ( Excel along with VBA and Macro. Please leave

Re: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

try this... If range("A1").value = " " Then Exit Sub Else Range("B5").Value = 8 End If End Sub regards, Mrinal On Thu, Nov 10, 2011 at 9:18 PM, Seba wrote: > Hi, > > I am testing this fairly simple code for some other purposes but I > always get the value 8 regardless of value in A1: > > -

Re: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

you forgot RANGE but to make sure try If len(application.trim(range("A1")))<1 Then Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Seba Sent: Thursday, November 10, 2011 9:48 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ excel v

RE: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

Hi Seba, You are missing a small thing.. I have made the required correction in your code. Sub testPogoja() If IsEmpty(Range("A1")) Then Exit Sub Else Range("B5").Value = 8 End If End Sub Best Regards,Kaushal Kumar > Date: Thu, 10 Nov 2011 07:48:10 -0800 > Subject:

Re: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

; Sent: Thursday, November 10, 2011 9:48 AM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem > > > Hi, > > I am testing this fairly simple code for some other purposes but I > always get the value 8 regardless of value in A1: >

Re: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem

; > > > > > > > > > On Thu, Nov 10, 2011 at 10:13 PM, dguillett1 wrote: > > you forgot RANGE but to make sure try > > > If len(application.trim(range("**A1")))<1 Then > > > Don Guillett > > SalesAid Software > > dguille...@gmai

$$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

I may regret asking this, but here goes: Using Office 2010: I have Excel templates that are used to create documents and store the data in an Oracle database. The Oracle database has data from "released" and "archived" or "historical" documents. These documents are saved as PDF's and stored

$$Excel-Macros$$ Excel VBA Password Issues/ Cannot view the code

I am new to excel and absolutely a novice to vb. I have been given a task to write macros code in vba in excel. The macro code is already there but nobody knows the password. So the button even in design mode doesnot show view code. I just want to view to code behind. I cant pass the sheet as it

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

Hi Everyone, I am new to excel vba programming. I found this macro goggling. It basically does what I want it to do. However, my data starts on row 6, column A. This macro starts on A1. I have other data above row 6 that I want to keep. This macro messes up the formatting. I can't figure o

$$Excel-Macros$$ Excel VBA to colorize cell based on another cell

I have approximatedly 34 different desired color combinations I would like to colorize certain cells based on selected value. I.e., in English, it would be something like: Black=0 :White=2:Red=3 :Green=4 Blue=5 :Yellow=6 :Magenta=7 :Cyan=8 Get value of AK40, call it "Supply"

$$Excel-Macros$$ excel vba code to change hyperlink default file path

When inserting a hyperlink the dialog box uses the path of the active workbook. I need code to change the hyperlink path to a sub folder and then insert a hyperlink with Application.Dialogs(xlDialogInsertHyperlink).Show, with that subfolder active. -- -

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Thank you so much Ayush:) On Mon, Nov 8, 2010 at 6:05 AM, Ayush wrote: > Dear Group Members, > > Good news for all of you !! > > Now you can download VBA macros ebook worth $45 for free. > > Here is the link to download :- > http://recordexcelmacro.com/discussexcel.html > > I have talked to

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Dear Ayush, Thanks a Lot:) *Best Regards,* *Venkat* On Mon, Nov 8, 2010 at 7:35 PM, Ayush wrote: > Dear Group Members, > > Good news for all of you !! > > Now you can download VBA macros ebook worth $45 for free. > > Here is the link to download :- > http://recordexcelmacro.com/discusse

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Thank u very much Ayush dear... Regards, Noorain On Mon, Nov 8, 2010 at 5:50 PM, Venkat wrote: > Dear Ayush, > > Thanks a Lot:) > > *Best Regards,* > *Venkat* > > > > > On Mon, Nov 8, 2010 at 7:35 PM, Ayush wrote: > >> Dear Group Members, >> >> Good news for all of you !! >> >> Now you can

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Thanks, Will always come in handy. Rgds, Chris On Tue, Nov 9, 2010 at 6:49 AM, NOORAIN ANSARI wrote: > > > Thank u very much Ayush dear... > > Regards, > Noorain > > On Mon, Nov 8, 2010 at 5:50 PM, Venkat wrote: > >> Dear Ayush, >> >> Thanks a Lot:) >> >> *Best Regards,* >> *Venkat* >>

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Thanks a lot dear Regards Sumit On Tue, Nov 9, 2010 at 10:19 AM, NOORAIN ANSARI wrote: > > > Thank u very much Ayush dear... > > Regards, > Noorain > > On Mon, Nov 8, 2010 at 5:50 PM, Venkat wrote: > >> Dear Ayush, >> >> Thanks a Lot:) >> >> *Best Regards,* >> *Venkat* >> >> >> >> >> On M

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Hi Ayush, What is the password to opent the file. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 8 November 2010 19:35, Ayush wrote: > Dear Group Members, > > Good news for all of you !! > > Now you can download VBA macros ebook worth $45 for free. > >

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Hey There is no password, I opened it without password. Regards Sumit On Tue, Nov 9, 2010 at 3:03 PM, Upendra Singh Sengar < upendrasinghsen...@gmail.com> wrote: > Hi Ayush, > > What is the password to opent the file. > (¨`·.·´¨) Keep > `·.¸(¨`·.·´¨) Smiling !! > (¨`·.·´¨)¸.·´ Upendra Singh

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Hi Sumit, Kindly mail me the PDF u've downloaded. (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 On 9 November 2010 15:22, sumit kumar wrote: > Hey > > There is no password, I opened it without password. > > > Regards > Sumit > > > > On Tue, Nov 9, 20

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Hi Ayush, Thanks a ton.. for the effort.. Something seems to be wrong at my end as the link you have given is not opening.. Is there any way you can send the file to me plz.. Cheers, Andy On Mon, Nov 8, 2010 at 7:35 PM, Ayush wrote: > Dear Group Members, > > Good news for all of you !! > > Now

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Hi Ayush, Thanks for the book.. It looks like a very handy resource to keep and refer to. Regards, Aindril On Tue, Nov 9, 2010 at 7:50 PM, ayush jain wrote: > Hi Andy, > > Attached is the book for your reference. *Please do not forward to our > Google group and let them download from the URL.

$$Excel-Macros$$ Excel VBA made easy : Cool Stuff for VBA beginners.

Dear members, I hope you are using this platform very well by helping others and reading solutions. I would like to share some material for people who want to understand Excel VBA - but can't get started. I have worked with John Franco (A great excel enthusiast) to get some material of VBA Macros

$$Excel-Macros$$ Excel VBA Macro for sending email through Lotus Notes

Hi Give below is the code I used to send email and attache attachement to the same email. Only success I had till now is in sending email and attaching same sheet as attachement. I am not able to attache a pdf and send it through email. Can some one please advsie me how can I attache a pdf file a

RE: $$Excel-Macros$$ Excel VBA: String manipulation and tally (Help Needed)

End Function Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pesh Sent: 29 July 2012 2:08 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel VBA: String manipulation and tally (Help Nee

$$Excel-Macros$$ excel vba userform using & data store in access database

Hi Everyone, I have created a userform where i want the data to be stored in access automatically, However i have written some code, where in start only i m getting error at the * Dim con as new adodb connection * Can some please tell me why is this error occurring, or how to come overview

Re: $$Excel-Macros$$ Excel VBA professional needed for a Project Work

Hi Satish Here is Divaker, you can contact to me on 9582060233. Divaker pandey On Mon, Oct 31, 2011 at 1:55 PM, satish wrote: > Dear Excel Gurus, > > I am free lance data analyst, I have set of excel templates to > calculate the Savings and Overcharges. I would like to auto-maize the > whole pr

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

This has most of it http://www.excelfox.com/forum/f13/execute-sql-excel-vba-66/ Regards, Sam On Mon, Mar 4, 2013 at 11:50 PM, Paul Schreiner wrote: > I may regret asking this, but here goes: > > Using Office 2010: > > I have Excel templates that are used to create documents and store the > dat

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

Hi Paul Helen Feddema's book Access : Working with excel covers all this and much more. If you want it for $10 instead of $17 you have to subscribe for the free newsletter Access Watch. http://shop.office-watch.com/awe/fasttrack.aspx On Tuesday, 5 March 2013, Paul Schreiner wrote: > I may regre

  1   2   >