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

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

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

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

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