[ExcelVBA] Re: Combining cell results in different worksheets

 

Greetings,

Yes that's what I am trying to do. When I concatonate any cells that have nothing in them they leave a blank between the concatonated fields of other cells [hope i said that right].

So I end up with master cell A1 containing the results from sheet t1 cell A1, sheet t2 cell A1, sheet t3 cell A1 > sheet t15 cell A1. They appear as follow:

27 19 ss 63 ss ss ss 39 21 ss ss 52 35 ss ss
[ss indicating where spaces appear]

and I wish to have:
27 19 63 39 21 52 35
[only display numeric values.]

--- In ExcelVBA@yahoogroups.com, "david braithwaite" <dbraithwaite@...> wrote:
>
> Hi
>
>
>
> It looks like you want (e.g.) C7 on master to contain appended C7 values
> from T 1, T 2,...,T 15.
>
> Why VBA, why not just use CONCATONATE at Excel Level ?
>
>
>
> Db
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (3)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___