+ Reply to Thread
Results 1 to 8 of 8

VBA help to limit code application to populated cells

  1. 04-28-2014, 11:01 AM #1
    shootstill
    shootstill is offline
    Registered User
    Join Date
    03-25-2014
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2011, Excel 2010
    Posts
    18

    VBA help to limit code application to populated cells

    Can someone help me to adjust my code so it is applied to the changing amount of rows in my range? 

    Please Login or Register  to view this content.

    Thanks!
    Reply With QuoteRegister To Reply
  2. 04-28-2014, 11:06 AM #2
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: VBA help to limit code application to populated cells

    Hi,

    Try this...

    Please Login or Register  to view this content.
    Regards,
    Rudi
    Reply With QuoteRegister To Reply
  3. 04-28-2014, 11:08 AM #3
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    24,029

    Re: VBA help to limit code application to populated cells

    I think this is what you meant.

    Please Login or Register  to view this content.
    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 With QuoteRegister To Reply
  4. 04-28-2014, 11:30 AM #4
    shootstill
    shootstill is offline
    Registered User
    Join Date
    03-25-2014
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2011, Excel 2010
    Posts
    18

    Re: VBA help to limit code application to populated cells

    I tried both of those, and they work great. But when I combined it with my other routine, I realized that might not be the location of my problem.

    I am running this recorded macro code to clean up some formatting right before the hyperlinks code I posted, (which I would like to combine, but don't know how) and I think my issue is in my recording...

    Sorry for the backwards step - any help would be greatly appreciated.



    Please Login or Register  to view this content.
    Workbook attached in case it would be helpful: Workflow Report Automation (EDIT).xls

    Thanks
    Last edited by shootstill; 04-28-2014 at 11:32 AM.
    Reply With QuoteRegister To Reply
  5. 04-28-2014, 02:06 PM #5
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: VBA help to limit code application to populated cells

    Try this...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 04-28-2014, 03:23 PM #6
    shootstill
    shootstill is offline
    Registered User
    Join Date
    03-25-2014
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2011, Excel 2010
    Posts
    18

    Re: VBA help to limit code application to populated cells

    Quote Originally Posted by RudiS View Post
    Try this...
    This breaks all the formulas that were copied-down in the recording, and the headings that were changed.
    Reply With QuoteRegister To Reply
  7. 04-28-2014, 04:13 PM #7
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: VBA help to limit code application to populated cells

    Apologies...when I was testing I was running the macro from the Workflow sheet, instead of triggering it from the button on the Instructions sheet. I had a variable that did not take this into account and it ended up counting the wrong values...

    Its fixed now.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 04-28-2014, 06:13 PM #8
    shootstill
    shootstill is offline
    Registered User
    Join Date
    03-25-2014
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2011, Excel 2010
    Posts
    18

    Re: VBA help to limit code application to populated cells

    Quote Originally Posted by RudiS View Post
    Apologies...when I was testing I was running the macro from the Workflow sheet, instead of triggering it from the button on the Instructions sheet. I had a variable that did not take this into account and it ended up counting the wrong values...

    Its fixed now.
    awesome - thanks a ton!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] data validation to limit amount of cell being populated in column A
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:14 PM
  2. data validation to limit amount of cell being populated in column A
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2014, 10:14 PM
  3. 2010 VBA Code for: format the print area to include only rows with populated cells
    By sambo24 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2013, 10:57 AM
  4. Charts - how to limit x-axis to rows with populated values
    By MCunningham in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-02-2013, 07:58 PM
  5. Conditional formulas: color code text populated cells?
    By TKT in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-28-2005, 10: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1