+ Reply to Thread
Results 1 to 3 of 3

learning the basics; macro / vba

  1. #1
    Registered User
    Join Date
    11-24-2009
    Location
    OSLO
    MS-Off Ver
    Excel 2003
    Posts
    66

    learning the basics; macro / vba

    Hi!
    I`m pretty new to macro and vba. I`ve been playing around a bit, and recorded some macros.
    The problem is the hard coding in the recorded macro. When making a pivot, adding a column etc, I get problems; especially with the pivot, that won`t work at all, because of the sheet problems...And the recorded macro also do stuff that are unnecessary - like all the select things.

    Anyway, I need to learn the basic coding, so I can make dynamic ranges etc. Is it a good source where I can learn this relatively quick?

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: learning the basics; macro / vba

    Hi Bandini,

    Check out the Tips & Tutorials forum (Click on Forum)
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,130

    Re: learning the basics; macro / vba

    Use Google to look up the scenario you want. There is lots of good stuff out there.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 02-12-2020, 02:47 AM
  2. To find activeCell's ROw numbebr and Column No in EXTra Basics using EXCELL Macro
    By balaalwar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 10:21 AM
  3. Basics of macro and VBA code
    By desurkarramesh in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 04-25-2012, 07:21 AM
  4. Learning VBA - Suggestion for Beginners Learning Curve
    By sighlent1 in forum Excel General
    Replies: 1
    Last Post: 08-26-2010, 12:58 PM
  5. Basics of macro
    By rkbhuvanesh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2008, 02:37 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1