Programming
in [Excel]
|
hours / minutes In my macro, I use the following code to return the total number of minutes between 2 times: TtlMins = Day2 - Day1 TtlMins = 545 What I want to do next is to return the number of hours (9) and the remaining minutes (5) into 2 variables but I'm not having much luck MyHrs = ???? MyMins = ??? If I try Tt... 28 Apr 2010 03:58
programming 33 tabs with 1 chart on each, 9 series lines per chart Hello, I'm a VBA beginner and I've tried the macro recording but it uses the activesheet. The examples I've found use named and/or contiguous ranges. They are not specific enough or too complicated, using arrays. Even though there is more code by explicitly programming, it is very clear. In an open workboo... 27 Apr 2010 17:57
Insert Formula based in cell user clicks In need to insert a simple formula into Column J based on the cell in the same row which is clicked by the user. Only one of the cells will be clicked and color changed between the following cells F,H,L,M or N. The formula is the product of 3 cells, 2 of which are fixed and the last one should become whichever... 27 Apr 2010 15:40
Turn a range of cells into 'read only' I want to turn a range of Sheet1 cells into 'read only' when my file is saved. The conditions are as follows: If range A1:A100 (a range of dates) = TODAY() Then range C1:C100 which corresponds to TODAY() is made 'read only' I don't know if it matters, but the sheet will be password protected. Can you help wit... 28 Apr 2010 17:29
Ignore Blank Cells I update a workbook weekly in separate worksheets. My master worksheet links to the appropriate cells for the updated data. These are simple percentage numbers (not forumlas, etc.) and only need to be a one-on-one link. The problem I have is that if one of the cells is blank, it returns a 0 and I need to to ... 27 Apr 2010 17:57
VBA code to protect cells Outside a given range hi there, I need to write code allow the user to enter dato only on cells that are unprotected. What I need is to protect cells outside a given range. On a 6 x 6 matrix, where N=3, protect all cells on rows and columns 4,5,6 4,5. If N=2, protect all cells in rows and columns 3,4,5,6. thank you in advance. ... 29 Apr 2010 18:05
2 codes in one sheet I have these codes (below) in 2 seperate sheets. Is it possible to use these codes in one sheet? If yes, where and how I have to put them? These are the 2 codes: 1st Code: In Workbook: ------------------- Private Sub Workbook_Open() StartBlink1 End Sub Private Sub Workbook_BeforeClose(Cance... 27 Apr 2010 15:40
Wrapping entries in a ListBox I have a macro that takes cell data from a spreadsheet and populates a ListBox. I have no problems getting the data I want into the ListBox, but I'd like to make it look neater. Many of the items I add are longer than the width of the ListBox. I'd like to wrap (and possibly indent?) such entries, but I can't... 27 Apr 2010 12:12
Call a Sub from another Worksheet I can't seem to get this to work: Dim wb As Workbook Set wb = Workbooks.Open("z:\journal entry.xlsm") Application.Run wb.Name & "!CreateSubmittal" The Sub CreateSubmittal is designated as "Public Sub CreateSubmittal()" or not. The Sub is in the THisWorkbook object or Module1. Neither works. Ide... 27 Apr 2010 12:12 |