+ Reply to Thread
Results 1 to 3 of 3

imbedded if statements in a for loop

  1. #1
    Registered User
    Join Date
    11-10-2017
    Location
    US
    MS-Off Ver
    10
    Posts
    2

    imbedded if statements in a for loop

    I have a set of spreadsheets/data that will be downloaded for different files. The data are parced by day, date and time. Different times on different days are required to be treated differently with mathematical functions later. The code I wrote initially shifted some of the data over to new columns, but not all relevant datum. Originally, I had >= in the conditionals.

    the code is here:


    Please Login or Register  to view this content.

    Any suggestions would be greatly appreciated.

    Thank you.
    Last edited by alansidman; 11-10-2017 at 07:22 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,940

    Re: imbedded if statements in a for loop

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    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

  3. #3
    Registered User
    Join Date
    11-10-2017
    Location
    US
    MS-Off Ver
    10
    Posts
    2

    Re: imbedded if statements in a for loop

    I did try going through the debug, but once I get into the if statements, nothing shows up.

+ 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. Loop with two statements
    By elmnas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2016, 08:39 AM
  2. [SOLVED] For loop with mulitple if statements.
    By Petter120 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2014, 02:31 PM
  3. Repeat or Loop VBA Statements
    By zede35 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2014, 03:19 AM
  4. Scrape XML with loop and if-then statements
    By bszen27 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-21-2012, 02:03 PM
  5. VBA Syntax to loop and do if then else statements
    By 1234567890 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-19-2011, 10:39 PM
  6. VBA Do...Loop Statements
    By liseladele in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2006, 06:57 AM
  7. imbedded if statements
    By ksusong in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 07:05 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