Topic profile page for Worksheet.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Worksheet.
Topic "Worksheet" was discussed 73,296 times on 1,752 sites in last 3 months
Started 1 day ago (2009-11-30 22:07:00)
by XavierCat
VBA: store and lookup data in add-in (.xla) worksheet? I was wondering, is it possible to save data in a worksheet of an add-in workbook (.xla) and then have a function lookup data from that worksheet ? I made the following custom function, where the user selects a zip code and the function looks it up in cells K4:K903 and then ...
Started 1 day ago (2009-11-30 21:55:00)
by PJones1
combine all but one worksheet Need help changing the macro, found online, to exclude the worksheet named DataEnrtry. Any ideas? I would appreciate your help. Code: Dim wrk As Workbook 'Workbook object - Always good to work with object variables Dim sht As Worksheet 'Object for handling worksheets in loop Dim trg As ...
Started 1 day, 1 hour ago (2009-11-30 21:25:00)
by Br3nt
Need help modifying Worksheet_Change script to work with a range of cells... Hi, I'm forcing a time stamp into F17 based on "Pass, Fail, or Untested[P14]" value in E17 using Worksheet_Change. So far, the script works for cell F17, however, I would like it to work for the range of cells F17:F500 based on values in E17:E500. ...
Started 1 day, 2 hours ago (2009-11-30 19:42:00)
by K Smith
 I have been trying find information on creating an Index of all worksheet tabs, within a workbook, that will continually update with changes to the tabs. I have tried through the code option, but I am clearly out of my element here........ Â
Started 1 day, 3 hours ago (2009-11-30 18:32:00)
by uncleslinky
Macro - change destination worksheet Hi there I have a feeling this is a very simple question however my VB skills are very basic. I have a macro which copy and pastes data. Code: ActiveSheet.Range("a1:a10").Copy Destination:=ThisWorkbook.Sheets(1).Range("a1:a10" ) Currently the data is pasted within the same ...
Started 1 day, 4 hours ago (2009-11-30 18:26:00)
by Beachson
Worksheet blank!!! but data still recognized??? I go into a big excel file I have and it's blank but when I click sort all the normal data is there same when I do a pivot table but nothing shows up for the workbook....where in the world did my data goooo!!!!!
Started 1 day, 4 hours ago (2009-11-30 17:46:00)
by BlackTiger
Data Validation And Worksheet Event . . Hi all, I have the below code in the worksheet change evet. In cells where I have data validation, the msgbox runs twice and I am not sure why. I stepped through the code and it does highlight the exit sub line but it ignores it. In the cells with/out data validation, the code runs ...
Started 1 day, 5 hours ago (2009-11-30 17:26:00)
by Gregg
 I have a worksheet configured as a timesheet, where each row represents a task performed. For any given day, I track the task(s) performed and the hours spent on each task, and there are many functions in the worksheet. The worksheet contains the following columns: Column A: blank column (not used for anything). Column B: series of...
Started 5 days, 21 hours ago (2009-11-26 00:45:00)
by rimjhim
Macro to populate a cell in the worksheet with tab name Hi, I am trying to link a cell in my worksheet so everytime the tab name is changed, the cell automatically picks up the new tab name. Any help is much appreciated.
Started 1 week, 1 day ago (2009-11-23 16:13:00)
by GEThomas
Importing a text file into excel worksheet with VBA where a value is null Hello All, Hoping someone can help me with importing a '|' deliminated text file into a worksheet where one of the values is null Below is my code Dim Fname As String Fname = "C:/File.txt" Dim RowNum As Long Open Fname For Input As #1 iRow = 0...
Started 1 week, 1 day ago (2009-11-23 14:45:00)
by rdlondon
compare two worksheet column and rows in different format I need to compare two worksheets, if records are not found then create a row in new worksheet using format of WS2. The format of two worksheets are different (ws1 project id as column and ws2 project id as row) WS1 format Name project 1 project 2 project 3 ...
Started 1 week ago (2009-11-24 00:40:00)
by JWILLEY
Paste filtered data from one worksheet to another My form makes sure all data is not filtered upon opening and closing. I use a listbox6 to populate textbox1. Then textbox1 is used to filter worksheet(Part). However, I am unsuccessful in pasting the filtered data from worksheet(Part) to worksheet(FilterPaste). I could ...
Started 6 days, 20 hours ago (2009-11-25 01:58:00)
by Excelgreenhand
Worksheet number Can anyone tell me how to reset the worksheet number in a workbook using VBA, although I have only one worksheet left (add and delete) the Sheet number now is 98? Thanks.
Started 4 days, 17 hours ago (2009-11-27 05:18:00)
by uniquo
protected worksheet and combo box code Hi, How to adjust this code when it is used in a locked worksheet? The data validation for the other cells work even when the sheet is protected, but the combos are unaccessible. Thanks '========================== Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _ ...
Started 3 days, 21 hours ago (2009-11-28 01:26:00)
by stuckagain22
How can I hide a worksheet based on a cell's value (TRUE/FALSE) I have worksheet which has several checkboxes for users to select options. For one of the checkboxes, if the value in the cell it is linked to is TRUE, I would like a worksheet to appear (normally it is hidden). If the value is false, then I want the worksheet to ...
Started 4 days, 7 hours ago (2009-11-27 14:30:00)
by fathead
Find last row, copy cell & paste to another worksheet Hi all, Can anyone help with this one. I'm working between 2 worksheets, a list of data held in worksheet 'Store' and some empty cells in worksheet 'Input'. I'm hoping to add some VBA code to the end of an existing macro to do the following: Find the last cell/row in ...
Started 4 days, 7 hours ago (2009-11-27 14:35:00)
by pujo
Lock worksheet question Can you lock a worksheet that is in a workbook to the point to where you can not even select a cell? All you can do is view the sheet? Thanks.
Started 3 days, 20 hours ago (2009-11-28 02:26:00)
by HOTPEPPER
Worksheet Functions in VBA I have always used worksheet functions in VBA with the following syntax Application.WorksheetFunction.NameOfFunction as this is the way it showed to do it in the help file, however I have seen a number of variations on this theme. In the following example, all the lines of code work ...
