Showing related tags and posts accross the entire site.
-
Need help finishing this code for a msgbox. If no is selected I want the Sub to End/Cancel, If yes is selected Sub will run its course. I have found plenty of info on making a msgbox but none show how to end the sub when no is selected. Sub Insert_Row() Dim Response Response = MsgBox("Are Cells...
-
The sheets I'm presenting will change in number of rows (i.e. the range is not constant) It is also a shared work book with protected sheets and rows, allowing the user to insert new rows. I'm trying to write a macro that will sort by column "g" in row 1 which is the header row but...
-
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"