Search results for query: *

Good day all! I have no idea where to even start. I would think a few nested Excel Functions would do it, but my brain has thrown in the towel. I am trying to come up with a quick spreadsheet showing an employee's commission (varies), their expenses (static $1800 per pay period), and the...

I have been searching for this one quite a bit, but cannot find exactly what I'm looking for. I need to figure out how to test for a blank cell, using OFFSET, 1 row below th eactive cell. Here's what I came up with: If Offset(0, 1) = "" Then Exit Sub Else Unfortunately...

I have written the following code to close all workbooks that are not named in the code. However, the code tries to close the specified workbook as well. D'Oh! I think I'm on the right track, but could use a helping hand. Sub CloseAllOthers() Dim wb As Workbook Dim wbName As String For Each...

Good afternoon, all! I have been searching for a way (or even a hint of) a way to do the following in a workbook I open with a GetOpenFilename macro: 1) Search for a certain string (ie. "Date of Birth") 2) Copy the values from the "Date of Birth" column into my original workbook (the one that...

I have written the following code. It's rather simple, and I SHOULD be able to figure out why it's throwing an "Error 91" at me. However, I think my wife has taken to beating me about the head with large blunt objects while I sleep and cannot figure this one out. I think it has to do with my...

Hi All! Really simple one for you. The stopwatch is running. Is there a way to have VBA check to see if an external file exists? Not to open, just to see if it exists. If not, how would I code a "close/exit" for the program? Program is excel 2000. Hopefully this isn't too simple for all...

Happy Friday!!! Is it possible to create a list of Range Names that is broken out by Sheet? ie.. Sheet 1 Names Sheet 2 Names Sheet 3 Names Range Name S1-1 Range Name S2-1 Range Name S3-1 Range Name S1-2 Range Name S2-2 Range Name S3-2 Range Name S1-3...

Good Day! I am trying to create some programming that would copy a Named Range from one workbook to another based on a selection within a drop down list box. I have searched and tried several things. None of which have produced any results worth mentioning. Any pointers, hints, or tricks...

Yes, it's me again. I've searched a ton on this subject, but can't seeem to find what I'm looking for. I am trying to have Excel automatically create named ranges based on the entry within a certain cell. For instance: - Have the name to be assign to the range be in row 1. - Data will be...

Here's one for you Sherlock Holmes wannabes. I copied a worksheet from workbook A into workbook B. Made some modifications and saved workbook B. During the modifications I entered all new formulae. Now, whenever i open workbook B password dialogue box opens requesting the password for...

The following code works fairly well, but I would like to trim it down a bit. I'm sure there are a lot of extra lines of code that I didn't need to put in. Any ideas about how to "clean up" my code woudl be appreciated. The code is a Workbook/Open Sub. The end result takes a table, creates...

How would I create a list, later used to populate a DD Box, of all worksheet names in a workbook?

I am a TOTAL beginner. Sorry for the simple questions. I'm trying to figure out how to write the code to have a list generated by copying ALL named ranges within a specific worksheet onto a second sheet. Amy help would be greatly appreciated. Thanks Tons!