Hi All
I managed to do this in a 2 part code, but was hoping to condense it into
1. Here is my original 2 step process:
The following stored the equated/evaluated value in a cell ( which I am
trying to avoid ).
Sub Get_Weight()
Dim tSht As Worksheet
Dim tRng As Range, c As Range
Set tSht = She
>
> Hi Paul, and thank you for your assistance
>
>
Turns out Excel has a 30 character naming limitation for Sheets hence the
reason for the unnamed sheets.
I have updated the code to reflect your suggestions as well as
ActiveSheet.Name = Left(cVal, 30).
Works a treat now.
Thanks again.
Mark.
Hi Eugene
This link provides an example of extracting data from multiple workbooks
and condensing it into 1 file:
https://msdn.microsoft.com/en-us/library/gg549168.aspx
As a side note, Ron De Bruin's website has some great examples:
http://www.rondebruin.nl/windows_articles.htm
HTH
Mark.
-
Hi All
I know the subject title is a little vague.
I have the following code which works relatively well, with the exception
of the summing of the split total.
So Column G which may have up to 30 rows and only has 4 values (A, B, C, or
D) which this code inserts rows separating these differing
Hi All
This is doing my head in.
I have a range of names:
A
2 Jackson Brown - Musician
3 George Cluney - Actor
4 Fidelle Castro - Afficianado
5 Someone
6 Someone
7 Someone
8 Someone
9 Someone
10 Someone
11 ETC
When I execute the following code, it works kind of ok
Hi all
I actually posted this in a different group a few weeks ago and didn't get
any results so I am trying my luck here.
What I would like to achieve is:
One of the Distribution Centers (DC - A) I send stock into also unloads
stock for another DC on the same site (DC - B). Many trucks arriv
Hi all
Someone asked me an interesting question ( Subject Header ).
I know and use Excel to send emails but have never considered if, at all
possible pointing to a specific email and automatically opening, copying
and pasting a range of data then close said email attachment without ever
havi
