Code Modification(repost)

Imebatilisha Ilichapishwa Oct 8, 2009 Kulipwa wakati wa kujifungua
Imebatilisha Kulipwa wakati wa kujifungua

I have attached an Excel file. As it is now with the value 8 in range "E4", it produces the numbers in? range("A9:J2010") and place them in range("O9:X2010")

The objective is that if I change the value in range("E4") to 6 then the result should start off like this:

1,2,3,4,5,6,7,8,9,10

1,2,3,4,5,6,11,12,13,14

1,2,3,4,5,6,15,16,17,18

if I change the value in range(E4") to 4 then the result should start off like this:

1,2,3,4,5,6,7,8,9,10

1,2,3,4,11,12,13,14,15,16

1,2,3,4,17,18,19,20,21,22

The code should be flexible to work with 8, 10, or 12 columns

And row right to the end of the work sheet.

Derick

Uhandisi Microsoft MySQL PHP Usimamizi wa Mradi Software Architecture Majaribio ya Software Visual Basic Windows Desktop

Kitambulisho cha Mradi: #2911592

Kuhusu mradi

Pendekezo 1 Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Wafanyakazi huru 1 wanaweka zabuni ya kadri ya $17 kwenye kazi hii

jack0stone

See private message.

$17 USD kwa siku 5
(Maoni 9)
2.6