Results 1 to 11 of 11

Why does this macro not work?

Threaded View

AstToTheRegionalMGR Why does this macro not work? 04-07-2015, 03:50 PM
mattmickle Re: Why does this macro not... 04-07-2015, 03:53 PM
AstToTheRegionalMGR Re: Why does this macro not... 04-07-2015, 03:55 PM
TMS Re: Why does this macro not... 04-07-2015, 03:57 PM
mattmickle Re: Why does this macro not... 04-07-2015, 04:00 PM
mattmickle Re: Why does this macro not... 04-07-2015, 04:04 PM
AstToTheRegionalMGR Re: Why does this macro not... 04-07-2015, 04:18 PM
mattmickle Re: Why does this macro not... 04-07-2015, 04:19 PM
AstToTheRegionalMGR Re: Why does this macro not... 04-09-2015, 10:50 AM
mattmickle Re: Why does this macro not... 04-07-2015, 04:21 PM
TMS Re: Why does this macro not... 04-07-2015, 05:42 PM
  1. #1
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Boston, MA
    MS-Off Ver
    Office 2010
    Posts
    172

    Why does this macro not work?

    I'm trying to go through some macro tutorials to teach myself, and the example they gave me does not work.

    Dim example As Range
    Set example = Range("A1:C4")
    
    example.Value = 8
    It didn't even explain what Dim, As, or Set mean, so I'm totally lost here. Anyone's explanation of how this works in addition to what I have written wrong would be very appreciated!

    I know that the goal of this is to make each of the cells within the range have a value of 8, I do not understand what this code does or why the website is giving me a code that won't work.
    Last edited by AstToTheRegionalMGR; 04-07-2015 at 03:52 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro work in personal workbook, doesn't work in other workbooks
    By Centexcel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-30-2013, 11:47 AM
  2. [SOLVED] Macro Doesn't Work Through Button, Does Work Through Developer ->Macros Option
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-27-2013, 11:55 AM
  3. MAcro does not work when certain cells in a work sheet are protected
    By Unnati in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2012, 03:38 AM
  4. Macro to collate data from different work books and different work sheets
    By bvdileep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2012, 05:34 AM
  5. Replies: 2
    Last Post: 07-11-2006, 11:15 PM

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