+ Reply to Thread
Results 1 to 7 of 7

Dont want total Column, just few rows will change with this VBA

  1. 02-21-2017, 04:49 AM #1
    rajeshn_in
    rajeshn_in is offline
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Dont want total Column, just few rows will change with this VBA

    Hi friends,

    I don't now title is correct or not.

    I have below code, to get Ascending order in column D from D6:D (including A5:P), But I want ascending order from D6 to D100, before D6 and after D100 rows did not effect.

    Thank you.

    Please Login or Register  to view this content.
    I tried with D6:D100, but not working.
    Last edited by rajeshn_in; 02-21-2017 at 04:51 AM.
    Reply With QuoteRegister To Reply
  2. 02-21-2017, 04:53 AM #2
    BellyGas
    BellyGas is offline
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Dont want total Column, just few rows will change with this VBA

    change 

    Please Login or Register  to view this content.
    to 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 02-21-2017, 05:00 AM #3
    rajeshn_in
    rajeshn_in is offline
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Dont want total Column, just few rows will change with this VBA

    Hi BellyGas,

    Not working.
    Reply With QuoteRegister To Reply
  4. 02-21-2017, 05:08 AM #4
    rajeshn_in
    rajeshn_in is offline
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Dont want total Column, just few rows will change with this VBA

    and One more thing is 

    Please Login or Register  to view this content.
    with above code line getting so much distrubance. Can any one delete this option
    Reply With QuoteRegister To Reply
  5. 02-21-2017, 05:08 AM #5
    BellyGas
    BellyGas is offline
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Dont want total Column, just few rows will change with this VBA

    Funny, works for me.....although to test I've taken that out of the worksheet selection change event and rem'd out some lines, oh and changed the worksheet addressing cos I couldnt be bothered to rename my sheet to the same as yours:

    Please Login or Register  to view this content.
    Last edited by BellyGas; 02-21-2017 at 05:11 AM.
    Reply With QuoteRegister To Reply
  6. 02-21-2017, 05:13 AM #6
    BellyGas
    BellyGas is offline
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Dont want total Column, just few rows will change with this VBA

    And mate....if that last post of yours is seriously asking for someone to delete a line of code for you.....you really, REALLY need to read through this thread: http://www.excelforum.com/excel-prog...materials.html
    Reply With QuoteRegister To Reply
  7. 02-21-2017, 05:47 AM #7
    rajeshn_in
    rajeshn_in is offline
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    698

    Re: Dont want total Column, just few rows will change with this VBA

    ok BellyGas, thank you,

    with below line, Automatically going to other cells, I don't want to go to other cell , I want to stay where I was entered data. using ' symbol before below line, error coming. 
    Please Login or Register  to view this content.
    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. Hide column if rows dont have any value
    By gandreso in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2016, 10:14 AM
  2. change order of rows and calculate total value
    By Pascal12345 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2013, 04:38 PM
  3. spreadsheet I need to sort but I dont want the rows association w/ each other to change
    By maryworking in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2013, 11:11 AM
  4. Total up a column as the value change on another
    By Fernando in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-28-2005, 09:06 AM
  5. [SOLVED] VB code to total up a column as the value change on a nother
    By Fernando in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2005, 06:06 PM
  6. VB code to total up a column as the value change on another
    By Fernando in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2005, 04:32 PM
  7. [SOLVED] Total up a column on change of another
    By Fernando in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2005, 01: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1