Search results for query: *

Skip, Thank you so much. Worked like a charm. Sincerely Chris In the immortal words of Socrates, who said: "I drank what?

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 think I'm on the right track here. The follwoing code is what I've come up with thus far. Private Sub CommandButton1_Click() Dim wbNEW As Workbook Dim NewFileName As String Dim wb As Workbook Dim Msg, Style, Title, Help, Ctxt, Response Msg = "Selecting YES will...

Skip, I know the flipping between sheets is NOT the best, nor the most efficient way, to accomplish what I am after. I further agree that explicitly defining everything is a much cleaner code with fewer opportunities for errors. However, I cannot figure out how to define a newly opened...

Skip, I have been beating my head against the proverbial wall trying to figure this out. The following code is throwing "Run time error 1004: Activate method of range class failed": Private Sub CommandButton1_Click() Dim Msg, Style, Title, Help, Ctxt, Response Msg = "Selecting...

Skip, I got it! Nevermind about the use of named ranges. Thanks In the immortal words of Socrates, who said: "I drank what?

Skip, Thank you for the correction of code, however, I still do not know a named range (ie. "Date_of_Birth") instead of a cell reference. Any ideas? Thanks In the immortal words of Socrates, who said: "I drank what?

Skip, Is it possible to use a named range instead of a cell reference in the following portion of code? With Thisworkbook.Sheets("old") .Cells(5, "C").End(xlDown).Offset(1).Select .PasteSpecial xlValues End With I have tried looking this up as well, but...

PHV, Excellent! Thanks In the immortal words of Socrates, who said: "I drank what?

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...

Worked like a charm! I would give out stars to all, but am not sure if that is "Kosher" or not. If so, let me know and I'll give them away like candy. Thanks to all In the immortal words of Socrates, who said: "I drank what?

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...

Skip, First, I have been remiss in welcoming you back to the community. Hope everything went well and recovery was smooth and painless. On to the important stuff...me and my problems. LOL What code would you recommend for switching between 2, or more, workbooks since you stated: '...

Skip, Yes, the CurrentRegion only selects the datatable I need to perform the find / copy / paste actions on. May I assume this is a "good" thing? What do you have in mind? In the immortal words of Socrates, who said: "I drank what?

Skip, My fault. I should have indicated that there are rows of information above the required data in the "Source" workbook. Bad form, I know. However, this is what I have to work with. I tried using MS Query, but it would not find the information I was needing to query on. Any other...

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...

Gotcha! Thanks, again. In the immortal words of Socrates, who said: "I drank what?

ck, SCORE!!!!!!! Thank you very much. I appreciate the help. Out of curiosity, what does declaring the "rangeempty = true" do for the code? BTW. Star for you simply for being patient. Plus you solved the problem. Thanks again. Chris In the immortal words of Socrates, who said: "I...

ck, Correction. I posted my last reply before the website was updated with your second posting. I have made the changes you suggested in your last post. I changed the line "rangeempty = False" to "rangeempty = True" as the code should check to see if the cell = "" (that would be blank...

ck, Changed the code as suggested above. Now code is displaying the "Master Census NOT Empty! Process Terminated" msgBox even though I have deleted all information from the range. Any other ideas? At this point I am willing to try anything. Thanks a TON for the help you are providing. In...