Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #110960

Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet

Show all headers | View raw

Hi Johan,

Am Fri, 31 May 2019 22:35:37 -0700 (PDT) schrieb JS SL:

> In one of the first codes it was;
>      For i = LBound(varNames, 2) To UBound(varNames, 2)
>      z = i + 10
> So, because I inserted also some columns in Sheet1 it was easy understanding to change i+10 to i+26 because I change the startingpoint to column AA.
> 
> You have change this part of the code to
>     LColSh1 = .Cells(5, .Columns.Count).End(xlToLeft).Column 
>     varNames = .Range(.Cells(5, firstSh1), .Cells(5, LColSh1))
> 
> So I thought I have to change it to
>     LColSh1 = .Cells(27, .Columns.Count).End(xlToLeft).Column 
>     varNames = .Range(.Cells(5, firstSh1), .Cells(27, LColSh1))

when you insert columns the new ranges will be calculated automatically.
The only thing you must change in the code is the range for the codes
when this range has changed.
Make some test without changing the range for the codes. Insert or
delete columns in both sheets and you will see that the output is always
correct.


Regards
Claus B.
-- 
Windows10
Office 2016

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet JS SL <jmslab@xs4all.nl> - 2019-05-30 03:22 -0700
  Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet Claus Busch <claus_busch@t-online.de> - 2019-05-30 14:07 +0200
  Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet Claus Busch <claus_busch@t-online.de> - 2019-05-30 17:38 +0200
    Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet JS SL <jmslab@xs4all.nl> - 2019-05-30 12:06 -0700
      Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet Claus Busch <claus_busch@t-online.de> - 2019-05-30 21:56 +0200
        Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet JS SL <jmslab@xs4all.nl> - 2019-05-30 13:42 -0700
          Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet Claus Busch <claus_busch@t-online.de> - 2019-05-30 22:56 +0200
            Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet JS SL <jmslab@xs4all.nl> - 2019-05-30 21:54 -0700
              Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet Claus Busch <claus_busch@t-online.de> - 2019-05-31 10:11 +0200
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet JS SL <jmslab@xs4all.nl> - 2019-05-31 22:35 -0700
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet Claus Busch <claus_busch@t-online.de> - 2019-06-01 08:59 +0200
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet JS SL <jmslab@xs4all.nl> - 2019-06-01 00:30 -0700
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet Claus Busch <claus_busch@t-online.de> - 2019-06-01 10:28 +0200
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet GS <gs@v.invalid> - 2019-06-01 04:06 -0400
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet Claus Busch <claus_busch@t-online.de> - 2019-06-01 10:28 +0200
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet JS SL <jmslab@xs4all.nl> - 2019-06-01 02:41 -0700
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet GS <gs@v.invalid> - 2019-06-01 15:20 -0400
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet JS SL <jmslab@xs4all.nl> - 2019-06-01 23:00 -0700
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet Claus Busch <claus_busch@t-online.de> - 2019-06-02 14:22 +0200
                Re: Count the sum of multiply values in one cell, registered as part of a textcode, combine them per column and show the results in the next sheet JS SL <jmslab@xs4all.nl> - 2019-06-02 09:22 -0700

csiph-web