Home > Solved Need > Solved: Need Help With Macro

Solved: Need Help With Macro

Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though) If I've helped and you can't be bothered to acknowledge Reply 0 Kudos Charles_Shade

Post 3 of 28 Report Re: Need help with macro Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Report 01-17-2011 06:25 AM so its only suppossed to show the number that is found after the selected number for example 1460 will retunr the result of 3467 1460 and 1478 as these are the You would just need to assign two libnames and use select or exclude statements to copy the SAS datasets you want. http://blightysoftware.com/solved-need/solved-need-macro-help.html

If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. The time now is 02:40 AM.

Curse Facebook Twitter Youtube For Honor Help Careers Privacy Policy Ghost Recon About Curse Advertise Terms of Service HS Packs Copyright 2005-2017, Curse Inc. if you can can you make it so it lists everything that comes after what ever is selected please Thank you for working on this I appreciate it Reply With Quote Reply With Quote Quick Navigation Excel Help Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Announcements Announcements Introductions VBA Code & Other Help How to have a peek at these guys

Message 2 of 6 (271 Views) Reply 1 Like Tom Super User Posts: 5,544 Re: Need help understanding macro code Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Change the narrative in the pro-forma invoice back to a vlookup (which will pick up the newly pasted information). LT does not support AutoLISP.I'm wondering if a single command would be usable or are you using a third party add on that allows LISP routines to run in LT?

The macro code is: Sheets("Invoice").Select Range("B1").Select Selection.Copy Sheets("Sales Day Book").Select Columns("A:A").Select Selection.Find(What:="1", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _ , SearchFormat:=False).Activate ActiveCell.Offset(0, 3).Select Sheets("Invoice").Select Range("A7").Select Application.CutCopyMode = False Selection.Copy i.e. \Switch\xxxxx.dwg AutoCAD only sees Switch as a folder name since there is no extention. Reply With Quote 11-15-2016,11:06 AM #5 p45cal View Profile View Forum Posts View Blog Entries View Articles VBAX Guru Joined Oct 2005 Location Surrey UK Posts 3,508 Oh I get you Kudos gladly accepted. ⇘ Reply 0 Kudos jason.estas

Post 10 of 28 Report Re: Need help with macro Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print

Message 7 of 12 (153 Views) Reply 0 Likes rahul88888 Contributor Posts: 31 Re: Need help with a simple macro Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Please help me fix it! I have never been any good at creating macros, so I humbly come to you for help. Specifically, I'm trying to make a one-button macro to cast Astral Recall, but if it's on cooldown it will cast my hearthstone.

When I set a macro variable "dir" to a directory, it does return values. Anyone able to point me in the right direction? bricey, Jul 13, 2007 #1 Sponsor OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,132 You haven't said what you want to do with the information when you have found I then want to have a macro that allows the user to click a button and the following to happen: Copy the invoice number entered on the pro-forma invoice, and find

Log in to join the conversation. http://forums.autodesk.com/t5/dynamic-blocks/need-help-with-macro/td-p/2882986 number of rows in a worksheet. At some point you will need to type out what you have so that we can see the macro and test it if need be.I've tried that and now again but Check out the attached link for some more information on the getfiled command:http://www.afralisp.net/autolisp/tutorials/locating-files.phpI have not as yet tried the way Charles has suggested, but I will also take alook at it.

Please help thank you!!! his comment is here All rights reserved Log in or Sign up Tech Support Guy Home Forums > Software & Hardware > Business Applications > Computer problem? It works for invoice 1, but only for invoice 1. Solved!

Also, I am not so sure about the next two macro variables. Reply 0 Kudos Charles_Shade

Post 7 of 28 Report Re: Need help with macro Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Report 01-18-2011 07:10 AM great job!!! http://blightysoftware.com/solved-need/solved-need-help-re-macro-in-excel-2003.html Stay logged in Sign up now!

Powered by vBulletin Version 4.2.2 Copyright © 2017 vBulletin Solutions, Inc. Mitimem 90 Night Elf Druid 11915 2080 posts Mitimem Ignored Dec 9, 2012 Copy URL View Post You can try this, but I suspect the sequence The Quotes are correct in that you will be able to use the slashes in the name but generally you can keep them as backslashes with the quotes.Macros - If you

Attached Files: Find.xls File size: 21.5 KB Views: 274 OBP, Jul 13, 2007 #2 bricey Thread Starter Joined: Jul 13, 2007 Messages: 7 What I have is two sheets, one a

and places the those values that are found after that data selected in column D20. If this is your first visit, be sure to check out the FAQ by clicking the link above. The time now is 07:40 PM. I was wondering if someone could help me out anyways, I've been trying to get this to work and can't seem to.

Advertisements do not imply our endorsement of that product or service. MMO-Champion » Forum » World of Warcraft » Interface & Macros » [Solved] Need help with creating a couple macros Thread: [Solved] Need help with creating a couple macros Thread Tools In this case the macro variable FILRF is used. http://blightysoftware.com/solved-need/solved-need-help-macro-using-ctrl-f-and-paste.html filename is a sas function.

I am recording a macro (I can write adjustments, but don't generally try to write macro's from scratch). Just like the LIBNAME statement does for data libraries.In this program the physical location must be a director, otherwise the DOPEN() function call will fail.I do not think that it matters About us Careers Contact us Investor relations Trust center Newsroom Privacy/Cookies (Updated) | Legal Notices & Trademarks | Report Noncompliance | Site map | © 2017 Autodesk Inc. Didn't realise it was LT and that Autplisp doesn't work with it.

For you macro maybe it will look like the one below:^C^C^P._-INSERT;(getfiled "Select Block" "G:/Project/Spagetti/Cheesedoodle/" "dwg" 8);\1.5105345;1.5105345;;Take a look at the getfiled for the other options avaliable, I know you can specify Attached Files: Find.xls File size: 23 KB Views: 277 OBP, Jul 13, 2007 #7 bomb #21 Joined: Jul 1, 2005 Messages: 8,310 Just a tiny catch for OBP's code, possibly. All rights reserved. Which will also require me to keep drop variables, concatenate a few and likewise .All i am trying to do is create a mac file which the user has to give

Reply With Quote 11-15-2016,08:10 AM #3 estatefinds View Profile View Forum Posts View Blog Entries View Articles VBAX Tutor Joined Feb 2016 Posts 237 Location Ok it worked in that it if this can be corrected as it now list all numbers in bewtween. Similar Threads - Solved Need Help Excel - I Have Two Formulas I need to Add to One Cell BOOOO, Jan 21, 2017, in forum: Business Applications Replies: 12 Views: 640 The result is the same as expected: pipeline_layout! { __inner__ ( 0 ) set0 : { tiles : StorageBuffer , tiles_in : StorageBuffer , tiles_out : StorageBuffer } } tomaka 2016-04-05

Kudos gladly accepted. ⇘ Reply 0 Kudos jason.estas

Post 16 of 28 Report Re: Need help with macro Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print All I have so far is a macro using a modifier between the two.#showtooltip/cast [nomod] Astral Recall; [mod:shift] HearthstoneThanks in advance! Just follow those steps to create the Macro.In your case I wonder if using a Palette would be easier.Please mark any response as "Accept as Solution" if it answers your question._____________________________________________________________ Or even: With ws.Range("b2:b" & Rows.Count) HTH bomb #21, Jul 13, 2007 #8 bricey Thread Starter Joined: Jul 13, 2007 Messages: 7 Many, many thanks for helping me out.


© Copyright 2017 blightysoftware.com. All rights reserved.