Search results for query: *

Hi The code below takes data from individual work cards (i.e., sheets("AD") below), and transfers it to a "central" sheet. Although the entire card is copied and pasted [Range("C16:P39")], not all lines are actually populated. The next paste looks for the first blank line in the "central" sheet...

Hi The code below takes data from individual work cards (i.e., sheets("AD") below), and transfers it to a “central” sheet. Although the entire card is copied and pasted [Range("C16:P39")], not all lines are actually populated. The next paste looks for the first blank line in the “central” sheet...

Hi all Here is my code Sub HideSheets() For Each sh In Sheets If sh.Name <> "Welcome" Then sh.Visible=xlVeryHidden Next sh Sheets("Welcome").Range("a1").Select End Sub This worked fine for ages. Suddenly there is this debugger kicking in. Can anyone spot why? Mark

Hi I have a sheet that hides all but the Welcome Sheet on Opening. Then people enter a user name & Password, and it makes their sheet visible. I just now added a sheet called "Inv Usage" (Or sheet6), and i would like to display it ALL the time. So whoever opens the workbook see THEIR sheet...

Hi I have a range that has as part of a string, values such as 6/8, meaning used 6 from 8. NOT June 8th. However when i extract this date (via a MID function) it returns the DATE value. How can i alter my fomula to tell it that, at source, this number is a FRACTION rather then a DATE. Thank...

I have this code. The formulas in row 4 copy themselves down. I think this is not running; Range("c5:bd&(lastrw.value)").Select What i am trying to do is calculate the results after resize, then paste the results as values. Row 4 is never overwritten, as it contains the formulas. Thanks Mark...

Hi I have a long data sheet. I am using a Index+Match formula to retrieve the first instance of a given criteria. I also need to retrieve the SECOND instance belonging to the given criteria. I cant use an OFFSET, since they next value is not necessarily the very next line. How do i do this...

Hi I have a long data sheet. I am using a Index+Match formula to retrieve the first instance of a given criteria. I also need to retrieve the SECOND instance belonging to the given criteria. I cant use an OFFSET, since they next value is not necessarily the very next line. How do i do this...

Hi I have some templates in Word that incorporate DATE fields. These are subjected to Mail merge and saved as new documents. I constantly encounter the problem of "changed dates" when opening the documents later. Is there a way to somehow paste the DATE as a value rather then the field code...

Hi I have a date range in column A, and corresponding values in B. I have a BAR chart running vertically parallel to the data, charting negative and positive values. Dates are ascending, at 7 days apart. The Chart horizontal gridlines are the same size as the spreadsheet row height, thus...

Hi I have HYPERLINKs in column B in excel. I would like column D to display the full and actual URL path. How do i do this? I believe i have already done this some time ago with a FUNCTION, but cant remember or recreate that.

Hi The following code attempts to protect several sheets within a workbook, but only those whose name begins with "Emp". Sub ProtectSheets() For Each sh In Sheets If Left(sh.Name, 3) = "Emp" Then sh.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True Next sh...

Hi I have a workbook that has several users, all of whom have their own input sheet. I need to restrict them to be able to only view their own sheet. I have a Users table, defining UserName, Password, WorksheetName. The Welcome sheet asks for input of username & pasword, and returns...

Hi I store data in one transaction sheet that pertains to various departments (Dep Column D). Each transaction has a Transaction Number (T/A) (Column A) and keeps increasing by 1. Each department has its own number sequence. I use an "entry sheet" with multiple transaction lines; when i am...

Hi I have a mail merged document that carries different dates depending on the mereged data. The DATE is not a merged field and canot be one. Since this is mostly the mergedate I currently use the DATE field with a picture switch. I would like to change this to a manually input date, that gets...

I operate a pivot table whose source data keeps changing. The problem i have is that while the NAME field keeps changing with new names, the list under the NAME HEADING in the pivot table keeps growing! it does not delete names that are no longer in the source data list. I often pick names from...

Hi I use a fieldswitch to present a date in a DATE format given by word. The data is in a mailmerge and the dates are "good dates" from excel. For some reason it does not work, and return the serial number of the date instead. All other numeric switch work well. Can anyone help? Mark

Hi I have a piece of code that starts as follows; Sub UpdateCalc() Set ShtSum = ActiveWorkbook.Sheets("Transactions") lastrw = ShtSum.Cells(Rows.Count, "b").End(xlUp).Row When running this code it breaks (highlighting "Set ShtSum") and gives me the following error; Compile error Variable...

Hi This is a simple piece of code Private Sub Worksheet_Deactivate() Sheets("TB").Select Range.("R1").Select Selection.ClearContents Sheets("BS").Select End Sub Why does it keep running non-stop?

Hi I have a workbook that summarizes data via a detail sheet. The detail sheet is populated using several input ranges located on other sheets in the same workbook. I need to restrict access to most worksheet to most people. What is the easiest way to achieve this? Mark