Showing related tags and posts accross the entire site.
-
Hi there, Firstly apologies if something similar has been answered before, or i've missed something very obvious, i'm by no means a VB expert. Background I have a Worksheet broken down into Sections, at the top of each Section I have a Macro for Users to Show/Hide (the Rows for) that Section...
-
Can anyone help? I'm after a macro which will search a row from column J onwards. If it finds data in a cell it will add a blank row below the row it's searching in & then paste the data to column D in the new row. It will continue to add new rows & copy the data in to them until it finds...
-
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...