Search results for query: *

I have created a spreadsheet in Excel 2013 which uses conditional formatting to identify the highest and lowest values in a (non-consecutive) range of cells within each row. The highest value cell in each row is given orange fill and the lowest is given green fill. A colleague has created a...

I have been given access to a second mailbox from which we can read and send emails - it appears as a separate mailbox within my list of Outlook accounts. What I need is for emails received from different but specific companies to be forwarded to other individuals within my organisation - for...

Hi all, I need to roll out some changes to some template spreadsheets I developed recently. My plan was to write up an Excel macro that would ask the user to navigate to the workbook. My macro would then open the workbook, change the formulae that need changing and save the workbook back in...

I have an Excel workbook which, when opened, generates a new payment number. A macro then checks the Payment List sheet to see if the list is full. If it is, a new line is inserted below the last entry. Option Explicit Dim numPayments As Long Dim numPaymentsMaxLength As Long Private Sub...

Hi, I have set up a userform with a combobox that I am dynamically populating from a number of named ranges - the range used is defined by other selections made on the userform. Everything works fine if the range being used has multiple rows but a couple of them are only single entry and...

Probably a simple solution to this one but I can't for the life of me work out what the problem is. Here's my code..... Sheet18.Unprotect Sheet18.Range("A8:E9").Select Selection.EntireRow.Delete Sheet18.Protect When I try and run this code I get a "Run-time error '1004': Select method of...

Hi all. I have created a workbook using VBA and the functionality is fine but I sometimes get a strange screen problem when entering data into the workbook. Basically, when data is entered the screen gets messed up with cells and data from one of the other sheets in the workbook. If I scroll...

I have a workbook which must not be closed if a specific cell (named CERTIFICATE_NO) is empty. Currently, I have this code..... Private Sub workbook_onclose(cancel As Boolean) If Sheet3.Range("CERTIFICATE_NO").Value = "" Then MsgBox "Please enter a Certificate Number."...

I'm trying to create a named range but am coming up against an issue. The cells are not contiguous, rather are split across different rows - for example, ='ECC Form 9'!$D$9:$K$9,'ECC Form 9'!$D$11:$K$11,'ECC Form 9'!$D$13:$K$13,'ECC Form 9'!$D$15:$K$15,'ECC Form 9'!$D$17:$K$17,'ECC Form...

I have a worksheet with a single large cell which takes text entry. However, when lengthy text is entered, the formula bar extends down the screen, hiding much of the worksheet. The rest of the cell is protected so users can't move the cursor to another cell. Is there any way to limit what is...

Hi all, I have a piece of code based on a couple of examples from TekTips which I am using to count the number of cells in a range which have a particular colour font. The colour of the font is chosen by selecting one of a number of cells with different background colours to match the various...

I have an application which automatically generates a file name based on report number and a couple of other parameters. Occasionally, this throws up an issue where the filename generated has already been created and Excel asks whether the user wants to overwrite the existing file. If the user...

Hi. I have set up a dynamic range in a worksheet but am getting a rather weird result - as can be seen in the attached screengrab, the range is including 5 empty cells below the last populated cell. I have checked that the 5 cells are empty - clicking CTRL+down takes me to the last populated...

I have a table as follows. A B C 13 Mar-2008 £2,095,154.10 14 Apr-2008 £1,808,448.11 15 May-2008 £1,027,256.12 16 May-2008 £965,029.63 17 Jun-2008 £3,112,928.28 18 Jul-2008 £1,937,584.56 I need to get the value from column C into a separate sheet based on the value of...

I have a spreadsheet which takes data from two others which the user selects using the Application.GetOpenFilename dialog box. I'm looking for an effective way of dealing with a user who either clicks Cancel or the Red X on the dialog? If this happens, my sheet gets messed up pretty bad! I was...

I'm trying to retrieve some data from a closed worksheet and was hoping to use Walkenbach's GetValue function but it keeps returning #REF. Private Function GetValue(path, file, sheet, ref) ' Retrieves a value from a closed workbook Dim arg As String ' Make sure the file exists If...

Thought it best to start a new thread for this one. I'm importing data from one workbook (A) into another (B) using the INDIRECT() function. I have overcome the issue of INDIRECT() only working with open workbooks (thanks to everyone who assisted with that one) but now I have another issue...

I have a spreadsheet (A) which is being partly populated via use of the Indirect() function from another spreadsheet (B). Now, obviously spreadsheet (A) will only populate if spreadsheet (B) is open so I'm looking for advice on the following : 1. What is the quickest way to force spreadsheet...

Sorry in advance if this is a stupid question but I'm a newbie to VBA in Excel and need some assistance. I have created a macro to check the contents of a few cells which, depending on the result, populates other cells. What I now want to do is for this macro to automatically run as soon as the...

Just a basic question - up to now I've been designing websites using Fireworks - what would be the benefit (if any) to me in switching to Photoshop? Thanks.