Macro to work on any cell?

[steviegee]

Hi all ,

i am pretty new to excel , but have been playing around with it for a while now, i am currently trying to record a macro to work on lets say cell A7

formula =RIGHT(A7,4) now i would like to apply this to another cell further down the A column, but it could be at any cell number, but the first will always be at cell A7, is this possible??

any advice / help would be greatly aprreciated.
Many Thanks.

steviegee

[shg]

Just copy the formula; the reference will adjust.

[steviegee]

Hi,


at the risk of sounding dumb, well i suppose i am really lol, if i copy formula down the column i will end up with #VALUE# errors, or #NA# errors, i do have other txt in column A also on different cell numbers,

could your answer be a bit more detailed please.
steviegee

[shg]

Maybe your question could be more detailed. Want to post an example of what you're trying to do?

[steviegee]

Ok,


Many thanks for your time

[VBA Noob]

You could try

=IF(ISNUMBER(SEARCH("My Result",A6)),TRIM(RIGHT(A7,4)),"")

VBA Noob

[yorkshirekid]

This isn't a reply - I'm asking for help on posing a new thread. I've searched all over and can't see how to start a new thread. I have a question to ask and can't get started despite being logged in. Apologies, but can someone help e please.

[martindwilson]

there's a new thread buton at top and bottom of each sub forum!
then again there may be problems as the option to edit one of my posts isnt there

[steviegee]

Hi again,

i tried the above formula , and got the error message of having too many arguments?

any ideas,
thanks
steviegee

[VBA Noob]

See if examples helps

VBA Noob

[steviegee]

Mighty clever, thank you,
can you explain the formula, as to what it represents,
very impressed.

[VBA Noob]

ISNUMBER(SEARCH("My Result",A6))

This part of the formula returns true if Cell A6 contains the text "My Result"

The true statement then returns last four characters to the right of A7 (Cell below). The trim function removes the extra space

TRIM(RIGHT(A7,4))

The False statement will return blank

,""

So put it all together

=IF(ISNUMBER(SEARCH("My Result",A6)),TRIM(RIGHT(A7,4)),"")

HTH

VBA Noob

[steviegee]

Very much so,
thank you for your time and help.
steviegee