Sorry I steered you in the wrong direction: there is no From property.
There is however a SentOnBehalfOfName property. You should be able to
assign your team's e-mail address to this property and obtain the
result you are hoping for.
Best wishes,
Rolf Jaeger
SoarentComputing
Give this alternative a try. It labels all non-empty cells all the way
to the last cell non-empty cell in the column:
Dim aCol As Variant
Dim bCol As Variant
bCol = ActiveSheet.UsedRange.Columns(A)
ReDim aCol(1 To UBound(bCol, 1), 1 To 1)
Dim i As Long
i = 1
Dim irow
Pls see attachment
--
-
--
(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´
Best regards,
Veer
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free
Why not we share some of our own useful codes or techniques (which can not
be easily found by a google search) which will save lot of effort and time?
:)
I am going to post some of the vb codes I wrote or got on the net.
I will post a function (tomorrow because I don't have it here!) I wrote
Great Thought Hemant !!
and I will try to post all these codes on our blog www.vbamacros.blogspot.com
accessible to all members all the times :)
On Nov 21, 4:49 pm, Hemant Hegde hemantbales...@gmail.com wrote:
Why not we share some of our own useful codes or techniques (which can not
be easily
Dear Mahavir,
I have done a solution from whatever I could understand from your sheet.
Please find attached the solution as per my understanding.
Let me know if you need further help.
Regards,
Andy
On Fri, Nov 20, 2009 at 3:57 PM, Mahavir Bhardwaj
virbhardwaj...@gmail.comwrote:
Pls see
Great Idea Hemant!!
Here goes my code!!
The following code is to Convert Currency to Words(Indian Style)
'Please make a Module and add the code...
Option Explicit
' Function for conversion of a Currency to words
' Parameter - accept a Currency
' Returns the number in words format
Dear All
please find enclosed herwith a file with my problem.
Pls help
Mahavir
2009/11/21 Aindril De aind...@gmail.com
Attach a file in reply to this email..
On Fri, Nov 20, 2009 at 3:55 PM, mahavir virbhardwaj...@gmail.com wrote:
i dont know how to attached file. pls tell me the
Hi ,
i have automated some websites which are based on HTML .
It automates login and password input and then it clicks login.
I am not able to figure out which object will be used to handle frames
on this webpage.
1)https://login.isso.db.com/websso/sso_ext_Logon.sso
Hello Rolf,
Can you plz put it in xls file?
Thanks
vr
On Fri, Nov 20, 2009 at 11:58 AM, RolfJ r...@pacificsound.us wrote:
This might work for you. Let's assume that the total numbers of
minutes is located in cell A2. The following formulae would calculate
the number of whole days, hours of
Dear All
In attach sheet through web query i retrive data from web page,when i run
the macro i get only current data
from web page, now i want to retrive historical data.
The form variable name isTxtDate in web query.How can i add post form
variable in web query.
or any other way to retrive
Hi Excel Gurus,
Thanks a lot for sharing your knowledge and solving queries.
I am planning to prepare a check list for my team member for a particular task.
I mean once they finish the working on the excel sheet and try to close that, a
pop up of check list will appear which state the steps to
Hi JMac
go to this adr.
http://www.rondebruin.nl/tips.htm
Regard Yngve
On 18 Nov, 12:59, JMac jsvi...@gmail.com wrote:
Hi,
I have a spreadsheet with a Date Entered column and a Days Open
column. Every time a new record is added, the date is put in the Date
Entered column and a formula in
Sir,
Many times, it happens that we apply a filter on one or more columns.
During the course of our handling and scrolling left-to-right or
otherwise, we often forget which columns have been filtered.
Is there a good and efficient and clear way of telling or highlighting
FILTER columns, e.g., if
Hi,
I have been trying to write a macro for executing commands in putty. I
am able to successfully login to putty, but i fail to pass commands in
it. Mentioned below is the list of commands that I need to fire in
putty.
ldap_delete_device_cdv.sh cstVTN=”TN input value”
ldap_delete_device_cdv.sh
15 matches
Mail list logo