Help with coding please. Newbie.
 

Hi, Trying to apply this :-

Where column = "TheOneIWant"
if row 24 and row < 65
then increment the number in each cell by 1

I'm familiar with VB but not Excel and in a mad rush for this!

Many thanks,
Kirk


--
kirkm
------------------------------------------------------------------------
kirkm's Profile: http://www.excelforum.com/member.php...o&userid=35814
View this thread: http://www.excelforum.com/showthread...hreadid=558105

Help with coding please. Newbie.
 

On Tue, 4 Jul 2006 04:52:49 -0500, kirkm wrote:

Hi, Trying to apply this :-

Where column = "TheOneIWant"
if row 24 and row < 65
then increment the number in each cell by 1

I'm familiar with VB but not Excel and in a mad rush for this!

for column x, code looks like this:

dim cell as excel.range
for each cell in range("x25:x64").cells
cell.value = cell.value+1
next cell

--
PL

Help with coding please. Newbie.
 

Thank you PL. That worked perfectly.
Can I ask another question please?

When I link to the spreadsheet from Access, many cells show as
as #Num!
Is there some way in Excel to make every cell display ok in Access?
(All of them are or can be text).

Thanks - Kirk


--
kirkm
------------------------------------------------------------------------
kirkm's Profile: http://www.excelforum.com/member.php...o&userid=35814
View this thread: http://www.excelforum.com/showthread...hreadid=558105

Help with coding please. Newbie.
 

On Wed, 5 Jul 2006 05:09:07 -0500, kirkm wrote:

Thank you PL. That worked perfectly.
Can I ask another question please?

When I link to the spreadsheet from Access, many cells show as
as #Num!
Is there some way in Excel to make every cell display ok in Access?
(All of them are or can be text).
[...]

AFAIR #Num values in Access means that you have non-numerical content in
Excel. Try to multiply all the values by 1 (maybe in separate column, that
will be imported/linked to Access except the current one). Or, if you have
some txt values (I mean, values containing characters other than digits
and/or decimal dot), build a numerical column with formula (using, for
example, the "ISNUMBER" excel function to distinguish)

--
PL

Help with coding please. Newbie.
 

On Wed, 5 Jul 2006 12:42:58 +0100, Piotr Lipski wrote:

On Wed, 5 Jul 2006 05:09:07 -0500, kirkm wrote:

Thank you PL. That worked perfectly.
Can I ask another question please?

When I link to the spreadsheet from Access, many cells show as
as #Num!
Is there some way in Excel to make every cell display ok in Access?
(All of them are or can be text).
[...]

AFAIR #Num values in Access means that you have non-numerical content in
Excel. Try to multiply all the values by 1 (maybe in separate column, that
will be imported/linked to Access except the current one). Or, if you have
some txt values (I mean, values containing characters other than digits
and/or decimal dot), build a numerical column with formula (using, for
example, the "ISNUMBER" excel function to distinguish)

PS: you also can link/import all the xls data as text, just concatenate (in
a separate column) an empty string at the beginning of every value, and
import this column instead of the current one.

--
PL