-
Using Excel 2003, I would like to automate the process of creating a worksheet from a template, got this working, then automate sending this worksheet to a defined distribution list. I tried recording a macro but it stops after the email is called without entering the recipients and then sending the...
-
Dear forum users and bloggers, I would be really greatful if you could help me with the following matter. I need to assign the "freight payer" which is either the sending or in some times the receiving plant, e.g. OT for Ontario etc. I have two columns "sender" and "receiver"...
-
The code is currently opening the file as you describe. The main reason we are implementing this code is for speed reasons. Based on that, I am trying to find the absolute fastest way to read this data. I had done some testing on my local PC and known network locations (with regular drive letters), and...
-
Hi, Or you could make a function out of it... Public Function HasComment(rngRef As Range) As Boolean On Error Resume Next HasComment = CBool(Len(rngRef.Comment.Text)) End Function
-
Thanks. Specifically, I mean through the Excel fx feature. When you invoke fx , you get the list of arguments with entry fields, a description of the function, and the opportunity to select help for that function. I haven't found any way to add the description and help.
-
How do you write a help file for an Excel VBA function that is displayed when a user clicks "help on this function"
-
Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks
-
I would like to receive an email notification with a hyperlink to an excel workbook whenever someone completes said workbook (actually a customized template we use for each of our individual projects). After a little digging, one approach seems to be to create a beforeclose event with a customized dialog...
-
Hi, The array2string macro below should do the job for you. I wrote it a long time ago when I was learning about Excel arrays and have used it constantly since then. By chance, its latest use was to to do exactly what you want. Assuming that your values are in A3:C3, the formula would be ... {=PERSONAL...
-
Jim I doubt this is the full extent of your issue, but using you example... Sub TransposeRng() Range( "A1:E1" ).Value = Range( "A1:A5" ).Value Range( "A2:A5" ).Clear End Sub Post back when you want this done for many columns