+ Reply to Thread
Results 1 to 13 of 13

putting 3 blank cells in between an area

  1. 04-23-2024, 07:31 PM #1
    Writingformulas
    Writingformulas is offline
    Registered User
    Join Date
    01-07-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    63

    putting 3 blank cells in between an area

    Hello


    I am wanting to put three blank cells in a data set, between 1700 and 1900

    I currently do it manually

    It is a very large data set


    Thank You
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-24-2024, 03:32 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: putting 3 blank cells in between an area 

    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 04-24-2024, 05:46 AM #3
    Writingformulas
    Writingformulas is offline
    Registered User
    Join Date
    01-07-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    63

    Re: putting 3 blank cells in between an area

    Hi where would I put this code exactly im using 365
    Reply With QuoteRegister To Reply
  4. 04-24-2024, 05:48 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,295

    Re: putting 3 blank cells in between an area

    Are you using the desktop client? VBA can't be used in the browser interface.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 04-24-2024, 05:49 AM #5
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: putting 3 blank cells in between an area

    Place code in a std module...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 04-24-2024, 06:02 AM #6
    Writingformulas
    Writingformulas is offline
    Registered User
    Join Date
    01-07-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    63

    Re: putting 3 blank cells in between an area

    I can use the desktop version
    Reply With QuoteRegister To Reply
  7. 04-24-2024, 06:04 AM #7
    Writingformulas
    Writingformulas is offline
    Registered User
    Join Date
    01-07-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    63

    Re: putting 3 blank cells in between an area

    i m unaware of where that is
    Reply With QuoteRegister To Reply
  8. 04-24-2024, 06:23 AM #8
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: putting 3 blank cells in between an area

    Where what is...
    Reply With QuoteRegister To Reply
  9. 04-24-2024, 06:30 AM #9
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,295

    Re: putting 3 blank cells in between an area

    I think the OP needs a hand-held tutorial about where to go to find a standard modules and to enter the code.
    Reply With QuoteRegister To Reply
  10. 04-24-2024, 06:30 AM #10
    Writingformulas
    Writingformulas is offline
    Registered User
    Join Date
    01-07-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    63

    Re: putting 3 blank cells in between an area

    How to enter the code I am so new to doing this
    Reply With QuoteRegister To Reply
  11. 04-24-2024, 07:25 AM #11
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: putting 3 blank cells in between an area

    Open file in post 5...
    Press Alt F11
    Insert Module...
    Paste Code...

    Untitled.png
    Reply With QuoteRegister To Reply
  12. 04-24-2024, 10:04 AM #12
    Writingformulas
    Writingformulas is offline
    Registered User
    Join Date
    01-07-2023
    Location
    USA
    MS-Off Ver
    365
    Posts
    63

    Re: putting 3 blank cells in between an area

    yes I do Thank You

    Worked as desired Thank You !!!!
    Last edited by Writingformulas; 04-24-2024 at 10:23 AM. Reason: Thank You for your help
    Reply With QuoteRegister To Reply
  13. 04-24-2024, 03:40 PM #13
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: putting 3 blank cells in between an area

    Happy to have contributed...Happy Coding...
    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. Putting a Text Box at the Bottom of a Chart Area
    By HRobertSI in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-15-2023, 07:07 AM
  2. Dynamic Print Area - Ignoring Blank Cells Containing Formulas
    By djc123 in forum Excel General
    Replies: 2
    Last Post: 04-23-2021, 01:42 AM
  3. Simple macro to set print area for all the non-blank cells in many sheets
    By dhcwong in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-12-2017, 06:40 PM
  4. Sorting is putting blank cells at top?
    By brendan2711 in forum Excel General
    Replies: 4
    Last Post: 07-16-2013, 07:29 AM
  5. Change Print Area to Disregard Blank Cells
    By misty0705 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2008, 01:25 AM
  6. Area charts and blank cells
    By Pat in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-17-2005, 02:05 PM
  7. Blank cells represented in area charts
    By cdoughty in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2005, 01:02 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