Search results for query: *

I could not find this question in the forums. Thought it would be a simple solution. I'm using Excel 2013 and have VBA code to select a worksheet. My worksheets are years 2013,2014, 2015. Depending on the command button on my userform, I update cells in a particular spreadsheet. In my code I...

I searched this forum looking for how to bring up the Excel SaveAs windows screen. I have a spreadsheet database that produces a worksheet resulting from the users search critera. I can bring up the print preview screen if they want to print the worksheet results. What I haven't been able to...

I'm having a problem accessing the defined names of my worksheet. I have names defined in my workbook and can access them like this: Private Sub Introduction_Click() MsgBox Evaluate("Itext"), vbInformation + vbOKOnly, Evaluate("Ititle") End Sub This is a simple message box showing the...

I have an excel workbook that's basically a small database. A vba userform accesses the data and has buttons that perform simple searches. I would like to access the userform without having to open excel. So I need to create a program or convert the vba into an executable. How can I do this...

I posted this in the Office 2003 forum and did not get a response so I'm trying this forum. I'm really stumped. I have two sheets (call it Sheet1 & sheet2). Sheet1 is: Name Team Position Bob 2 1 Dan 5 3 George 1 2 Mac 1 1 Ted 2 2 this sheet is sorted by name...

I'm stuck again and this time it's turing my hair gray! I have two sheets (call it Sheet1 & sheet2). Sheet1 is: Name Team Position Bob 2 1 Dan 5 3 George 1 2 Mac 1 1 Ted 2 2 this sheet is sorted by name. Sheet2 is a report that looks like: Team 1 PlayerA team 1...

I have a spreadsheet containing 45 different rows representing network lines, a column has line speeds (128,256, 512..) and another column has the maximum Kbps for that particular line for a particular day. I'm trying to retreive into a cell the maximum Kbps for a line speed. I know the large...

cannot find a date using "Find" in excel. I have dates in the first column in format "mm/dd/yyyy" and need to find the row the date is in. I'm using the following lines and the result is the date is not found. I tried using the 11/12/2003 as a number, a string,as a...

I havee two files(workbooks) 'A' is a summary of another workbook 'B'. Workbook 'A' has a list of names and a associated value, 'B' has the details with worksheets matching a name field in the 'A' workbook. As follows: WorkBook A B column...

I'm writing a simple VBA program based on Excel which is no longer simple. Simply put, I have a workbook containing worksheets of people's names and their bowling scores. I have another Excel workbook which includes the list of bowlers and their average and handicap which is the last line of...