Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Macro (RSS)

Browse Site by Tags

Showing related tags and posts accross the entire site.
  • need help writing a marco to read txt file with conditions

    So i have an assignment which involves this type of problem. Bassically, I have a txt file with numerous rows of data, in the form: Name, Date , Latitude , Longgitude. I need to write a macro which displays all of the data OR just the data from a specifed name. Rather than copy the acutal assignment...
    Posted to VBA (Forum) by jethro197 on Sun, Oct 28 2012
  • Sorting a range for a varying number of rows in ascending order in a spreadsheet containing headings across multiple rows

    Normal 0 false false false EN-AU X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt;...
    Posted to VBA (Forum) by vbabeginner on Sun, Sep 2 2012
  • How to insert formulas into cells within a list of data

    Hello all, I am very new to excel and I need help. Currently, I am writing a macro to populate results into a newly inserted column C (date and time) after I captured info from column A (dates) and column B (time) for a list of data that could easily go beyond thousands row of records. So far, I managed...
    Posted to VBA (Forum) by Pauline on Thu, Dec 29 2011
  • adding macro

    hey I need help writing a macro that adds 2 values in a col. and then carries the total and keeps going to row 5000. The problem is the number of rows inbetween each number is always variable and the sum needs to return to the same position(if that cant be done results can be move to col B). For example...
    Posted to VBA (Forum) by delta on Sat, Jun 18 2011
  • Error when selecting page itme from pivot table - Runtime error 5 - Invalid Procedure Call or Argument

    Please help! I have spent way too much time trying to figure this out, so I'm really hoping someone can help. I have recorded vb that changes a page item in a pivot table when selecting from a combo box - similar to this video. http://www.datapigtechnologies.com/f...s/pivot10.html . The recorded...
    Posted to VBA (Forum) by lala14b on Thu, Oct 14 2010
  • macro for defining range

    I have a large amount of data in a spreadsheet. I am tracking various data by part number. This workbook is sorted by Part number (column "A"). I am wanting to write a macro to find the largest number (in Column "G") for each group of duplicate part numbers. Once this number is found...
    Posted to General (Forum) by ajb999 on Thu, Sep 16 2010
  • How to stop users moving a cell by accident

    Hi All I have a protected worksheet where all but a dozen cells are locked. The unlocked cells are in A1:A12. Occasionally, instead of entering data into A1:A12, the user will drag one of those cells onto another one unintentionally. Often they have no idea that they have moved a cell. Formulas in columns...
    Posted to General (Forum) by keghead on Sun, Nov 15 2009
  • Combining Two Sets of Data

    Hi, I have put this in the general section as I don't know if I need VBA or if I can do this with a look up. Basically I have two sets of data; Set 1 eg. Promo Code Detail Creative Offer Expense Date Live XF2 PPC Promotion Jan 09 N/A 10% Off $2000 1/1/09 GGH Geographic Magazine Jun 09 Red 15% Off...
    Posted to General (Forum) by rebsbails on Wed, Oct 7 2009
  • Match data on 2 different excel files and Copy - Macros

    Not sure if there is really any Macros Solution for my situation here I got vexed tuning my script. I have 2 .XLS files F1, F2 with multiple sheets and data on merged cells. In F1 under column B for cells from B30 to whatever be the last used row I have few set of values (text). In F2 under column B...
    Posted to VBA (Forum) by gotovamsee on Thu, Feb 12 2009
  • msgbox - cancel sub when selecting "No"

    Need help finishing this code for a msgbox. If no is selected I want the Sub to End/Cancel, If yes is selected Sub will run its course. I have found plenty of info on making a msgbox but none show how to end the sub when no is selected. Sub Insert_Row() Dim Response Response = MsgBox("Are Cells...
    Posted to VBA (Forum) by Gila on Wed, Dec 10 2008
Page 1 of 3 (25 items) 1 2 3 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.