Closed Thread
Results 1 to 2 of 2

Help with fixing an easy macro :)

  1. #1
    Registered User
    Join Date
    04-08-2013
    Location
    Wajdušna
    MS-Off Ver
    Office 365
    Posts
    80

    Help with fixing an easy macro :)

    Hello

    I dont have a lot of knowledge about VBA so i would like to ask if someone can fix my code so that it will work as it should :D

    i will add a excel workbook with the first sheet where there are informations needed for the if statment.
    I want my code to start in cell G1 and go down to the last row where there is a value and then offsets itself to the first blank.
    After that it should go to the left to the column C where the date and activate the cell, my logic which is flawed then wanted to check with If statment
    if in cell one to the left of active cell in this case would be B4 is bigger then a value in cell B3 it should put a value of 0 in other cell
    else do something else :D

    The problem with my code is that my if statment dosent work
    the code is :
    Please Login or Register  to view this content.
    Any suggestions or advice how to better set the code would be also most wellcomed.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,709

    Re: Help with fixing an easy macro :)

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    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

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Fixing Bullet Lists with VBA Macro
    By craig.bickett in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-10-2016, 03:17 PM
  2. [SOLVED] Fixing Update Macro
    By bgrish3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2016, 12:37 PM
  3. Help please fixing a macro
    By tyleromaha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2012, 12:07 PM
  4. Need help fixing macro
    By Kb24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2009, 03:19 AM
  5. Fixing macro to choose a blank row
    By nick.marcell@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2006, 02:15 PM
  6. Fixing SSN's with a macro
    By Bruce Martin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2005, 02:05 AM
  7. [SOLVED] Fixing a macro
    By Tim Dolan in forum Excel General
    Replies: 13
    Last Post: 01-18-2005, 11:06 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