Search results for query: *

Hi John, I just wanted to tell you that I got my code working, I think the error was comming from the fact that my sheet was protected, so I put in a sheets.unprotect line and the error resolved itself. I also put in a Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not...

The error occurs on the first line of code after "Case 2" even after i put the code in "module 2." I put the code in a new worksheet and it worked fine. I take that to mean that I must be doing something wrong elsewhere in my code, but i'm not sure where, or even where to look. I don't know if...

John, Thanks for replying so quickly. I put this code in "sheet1", i'm not totally sure where to put it, but I keep getting a "Run-time error 1004, application-defined or object-defined error" when i hit the "run sub/userform" (the triangle play button) Sub SelectCase() Select...

Hi skip, It turned out to be a pretty simple problem. I moved the code to the "this workbook" and had to add a "Next oCtrl" after each Find control. I do appreciate the help however, and maybe I will get to the point where I don't have to bother other people for help, we'll see though...

Hello all, I'm trying to insert an algebraic formula into a Range of cells depending on the value of cell("F1"). For instance if cell("F1")=1 then I want to use formula A, if cell("F1")=2 then I want to use formula B, and so on. Currently I have a simple Function set up with If/Then...

Sorry, I haven't gotten back to you sooner, I've been preoccupied with other things, I will try your suggestions, and thank you very much for the help. Thanks, Andy

First, excuse me for my imprecise diction, and second I have to admit that I am a relatively novice programmer. By bring up, I mean any time that I open a new excel workbook, either by selecting "File New" in the excel window that has the worksheet that contains this code, or after completely...

Hello All, I have sucessfuly disabled the save, save as, and other functions in the current workbook that I'm working on, but now these functions are disabled in any excel workbook I bring up. Is there a way to fix this? This is what my code currently looks like in "ThisWorkbook" Private Sub...