Need excel expert

[kashif.special2005]

Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
1<SUP>st</SUP> Question:- I am applying loop in cells that if cells value is alphanumeric than convert it into numeric and if cells value is numeric than next loop
<o> </o>
I am using this code but it is not working
<o> </o>
For j = last_row To 2 Step -1<o></o>
<o> </o>
cell_value = Cells(last_row, 1).Value<o></o>
<o> </o>
If IsNumeric(cell_value) = True Then
Next j<o></o>
Else<o></o>
Cells(last_row, 1).Value = Value(Trim(Mid(Cells(last_row, 1), Cells(last_row, 1), Len(Cells(last_row, 1))), Cells(last_row, 1)))<o></o>
End If<o></o>
Next j
<o> </o>
<o> </o>
2<SUP>nd</SUP> Question:-<o></o>
<o> </o>
'Range("H2:H" & last_row).Formula = "=Value(TRIM(IF(ISTEXT(A2),MID(A2,2,LEN(A2)),A2)))"
<o> </o>
When I am applying above formula it is working fine, but when I am applying below formula it is giving me an error.
<o> </o>
Please help<o></o>
<o> </o>
'Range("H2:H" & last_row).Value=application.WorksheetFunction.TRIM(IF(ISTEXT(A2),MID(A2,2,LEN(A2)),A2))
<o> </o>
<o> </o>
Thanks,
Kashif.<o></o>

 

[Weaver]

Hi,

I am still waiting for answer.....

Thanks,
Kashif.

Sorry mate, I didn't realise I was being timed.

Bang goes my KPI's for this month...

 

[GlennUK]

Sorry mate, I didn't realise I was being timed.

Bang goes my KPI's for this month...

 

[Ruddles]

Re: Penguin for sale

Before anything else ... why, oh why, oh why, do you never use a meaningful thread title?

Because he still gets replies regardless of the thread title?

 

[GlennUK]

Re: Penguin for sale

Because he still gets replies regardless of the thread title?

ha ha, so true.

 

[JackDanIce]

Weaver and Glenn, you're both banished to the naughty step!

Ruddles is it hard cash you want for the penguin or can I bater by offering a genetically modified disease free Spanish cucumber? Ok, I'll also include a bag of German brussel sprouts, but that's my final offer!

 

[Kentman]

Re: Penguin for sale

Yeh but the most important question has still not been answered.......how much is the Penguin?

 

[Ruddles]

Re: Penguin for sale

Ooh, I'd bend over backwards for a nice Spanish cucumber (to coin a phrase).

As for the penguin, I'm afraid you're all too late: a Nigerian prince has offered me part-share of a multi-million dollar inheritance and little FrozyToze has just set off down the River Severn en route for Lagos with a canister containing my life savings strapped to his left leg.

In a few weeks time I shall be rich enough to buy this entire Web site!

 

[JackDanIce]

Oh dear Ruddles, I think you didn't read the small print of the Nigerian Prince's multi-million dollar inheritance... you forgot to include your bank account details and your national insurance number for the Prince to make a small withdrawl in order to then deposit the inheritance. Honestly, back to the naughty step, go on, be gone with you!

I, on the other hand, donated to a poor desolute orphan of a child, who's only friend, was once a 4-legged goat who had unfortunately met it's demise, quite seriously, in an accident involving scissors and ginger.

It's karma, what goes around...

 

[Ruddles]

Did OP ever find his Excel expert?

 

[JackDanIce]

I saw a sign for a yellow bricked road, some discarded pair of red women's shoes and a slightly battered, worse for wear house, who's owner hadn't paid it's renewal for protection against acts of God insurance.

Would that sign be the way to the mystical expert in Excel?