Home > Solved Help > Solved: Help On Another Macro

Solved: Help On Another Macro

Private Sub GetNotes(ByVal Target As Range) If Target.Address = "$D$10" Then If Range("D10").Value = "MyText" Then Range("C15").Value = "This is what happens when D10 is equal to the text I want." I tried to us vlookup but it still wouldnt work. Solved: Help on another macro Discussion in 'Business Applications' started by djangojazz, Feb 12, 2007. The data for their number of absences is stored in Names worksheet. http://visu3d.com/solved-help/solved-help-revising-a-macro-vba.html

Initially you'll see the Template sheet is all errors, so what the macro does is (a) plug in sheet names sequentially (b) "clone" the template sheet (c) hard-code the cloned sheet Any ideas?Private Sub CommandButton1_Click()Dim counter As IntegerDim openedWorkbook As WorkbookDim sourceSheet As WorksheetDim strFileToOpen As StringDim continue As BooleanDim result1 As StringDim result2 As StringDim result3 As StringDim x As StringConst Ask a question Member requests are more likely to be responded to. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 28 ; 29 run; 30 31 32 33 %macro test_for_i; 34 %do i = 1 %to https://forums.techguy.org/threads/solved-help-on-another-macro.543498/

The book's generalist orientation provides an organizational framework as well as history, biographical material on leading macro social workers, illustrative contemporary examples, and factual data that offers real life detail. Slide1.JPG ‏77 KB Slide2.JPG ‏139 KB 0 Kudos Reply The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. The time is not converting on the sum function anymore properly at times. Report tipusalman87- Aug 25, 2009 at 03:47 PM I love you WutUp WutUp!

Let me explain. Thanks so much Bomb, it works faster, more secure, has less lines of code to process, and does exactly what I want. Any suggestions on learning some VBA more on my own? I need help using creating a macro that finds corresponding/matching values.

Subscribe to our newsletter Sign Up Team Terms of Use Contact Policies CCM Benchmark Group health.ccm.net Yes No I don't know View Results Poll Finishes In 8 Days.Discuss in The LoungePoll History About Us | Advertising Info | Privacy Policy | Terms Of Use and Sale | Call PVValue() Helpful +5 Report rizvisa1 4482Posts Thursday January 28, 2010Registration date ContributorStatus January 6, 2016 Last seen Apr 19, 2010 at 10:21 PM see these parts of thread. Yes, my password is: Forgot your password?

Im new with VMB and I've been working on this for 2 weeks now. Hugs from a trainee in Sweden :) Report Ganesh- Aug 24, 2011 at 06:51 AM Thank you very much!!! By using this site, you accept the Terms of Use and Rules of Participation. End of content United StatesHewlett Packard Enterprise International CorporateCorporateAccessibilityCareersContact UsCorporate ResponsibilityEventsHewlett Packard LabsInvestor RelationsLeadershipNewsroomSitemapPartnersPartnersFind a PartnerPartner Heya,In slide 2 you have a condition "and false", so that's always false.

  • The downside with the macro recorder is that it'll generate heaps of superfluous crap, but by studying it and experimenting you've a fair chance of figuring what you can strip out
  • But I wholeheartedly followed your instructions when I had a similar problem of calling a macro, to limit the characters in a cell, when a cell is populated, and you know
  • and Points<0 order by ID; quit; %end; %mend; %redlist() Now, someone said and remember reading something along those lines that I cannot reference a macro (&i) in a select statement in
  • Any help is much appreciated and the old code is attached but here it is as well.
  • Board index The team • Delete all board cookies • All times are UTC + 1 hour [ DST ] Forum powered by phpBB © phpBB Group By any use of
  • Otherwise you will lose them at the end of the macro execution.
  • Report Imlost- Apr 28, 2016 at 02:54 AM awesome description and work too..
  • Meaning when I hit my quick key could it just be smart enough to convert Waldo and Ken without having to click on each sheet to do them?

Helpful +6 Report Bhumi Mar 13, 2009 at 08:13 AM Hi I am very new to VBA. Discover More Tech Support Guy is completely free -- paid for by advertisers and donations. If that is the case is an event driven routine. You solved a problem I've worked with for over a week!

I want to buy you a beer for this! Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content ‎07-21-2016 08:44 AM You should declare the macrovariables outside the macro (or FTR, the actual macro is slimmed down considerably courtesy of the method, i.e.: Sub Templates() Application.ScreenUpdating = False For Each Sheet In ActiveWorkbook.Sheets If Sheet.Name <> "Template" Then Sheets("Template").Copy After:=ActiveWorkbook.Sheets(Sheets.Count) ActiveSheet.Name Register now Not a member yet?

client script = 'macros.dms' macro_mode = 1 Copyright © 2017 BYOND Software. Anyone? Do you have any solution? weblink Can anyone help?

All rights reserved. Stay logged in Sign up now! I will provide a file to go along with the explanation.

I think I have the right code, but I don't know how to correctly begin or end it.

Many thanks in advance if possible or not Report Anonymous- Nov 18, 2015 at 03:04 PM Try using brackets after the name of macro e.g. Similar Threads - Solved Help another Macro Help Please Dave-o-saurus, Mar 1, 2017 at 6:30 PM, in forum: Business Applications Replies: 0 Views: 33 Dave-o-saurus Mar 1, 2017 at 6:30 PM Initially you'll see the Template sheet is all errors, so what the macro does is (a) plug in sheet names sequentially (b) "clone" the template sheet (c) hard-code the cloned sheet Since you are using Excel 2007, this is what you do. 1) Click on the Developer tab. 2) Click on the Visual Basic icon. 3) On the left pane window, double

What am I doing wrong here? I need help using creating a macro that finds corresponding/matching values. Capture.JPG ‏28 KB 0 Kudos Reply Lukus Frequent Advisor Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content ‎09-04-2016 07:03 PM Any ideas on the code why? 3.

Showing results for  Search instead for  Do you mean  Menu Categories Solutions IT Transformation Internet of Things Topics Big Data Cloud Security Infrastructure Strategy and Technology Products Cloud Integrated Systems Networking djangojazz, Feb 19, 2007 #5 Jimmy the Hand Joined: Jul 28, 2006 Messages: 1,221 I think the collection should be specified more explicitly. (For Each c In rngClear.Cells instead of For I just am getting tired of having to copy and paste sheet after sheet to do the function the macro is doing. Computing.Net and Purch hereby disclaim all responsibility and liability for the content of Computing.Net and its accuracy.

Report qedleao- Jul 9, 2010 at 09:30 AM SandsB Hi, I encounter the same problem today but, as I wanted to download the file WutUp posted with the explanation I could Code: Option Explicit Sub ConvertTimeData() 'Delcare variables Dim ws As Worksheet, wsOrig As Worksheet, i As Long 'Set variables Set wsOrig = Sheets("Translator") 'Change as needed/desired 'Set application properties for effeciency Join our site today to ask your question. Bibliographic informationTitleThe Practice of Macro Social WorkAuthorWilliam G BrueggemannEdition4PublisherCengage Learning, 2013ISBN0495602280, 9780495602286Length552 pagesSubjectsEducation›Teaching Methods & Materials›Arts & HumanitiesEducation / Teaching Methods & Materials / Arts & Humanities  Export CitationBiBTeXEndNoteRefManAbout Google Books -

for #1, after: 'Leave data as static values ws.Range("A450").Value = ws.Range("A450").Value try: ws.Range("A4:A50").Replace What:=" *", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False #2, "The time is not converting on the sum function anymore Compare Excel | Excel Templates | DownloaderXL Pro Finance Templates & Add-In Bundle | NeuroXL Predictor | Construction Estimating Merge Excel The Easy Way | Trading Add-ins For Excel Once the balance is positive, those points would be used as the starting point when deducting the next negative points. Wow, mixing templates with VBA code is above my head but that works SO much better.

Report Aaaacke- Nov 10, 2009 at 06:33 AM THANK YOU! Register Login BYOND Forums Announcements · BYOND Help · Bug Reports · Feature Requests · Beta Testers · Beta Bugs · Developer Help · Design Philosophy · Demos & Libraries · outside of the macro. I'm using Excel 2007 if it matters.

You may have to register before you can post: click the register link above to proceed.