Recent content by Benoni2

Hey, thanks so much you guys. It worked great. I was hoping to do it vb, but this is much faster, waist of time trying to program it the other way. thanks.

as follow up, the colums don't line up well in my tables above, but I think you can get the idea. However, in the second table, it's important to note that agencyID is empty all the way down. The three columns apply to the last three column titles, Idnum, data1, and data2

So here's a fun question I would really appreciate some help on. The actually problem uses more complex data, but if anyone can help me solve the problem below, either with a VBA example or through querries, I would really appreciate it. Okay, so: Two tables: Table 1 AgencyID Begin R End...

I used the code: activesheet.unprotect ("password") activesheet.protect ("password") around my spell check macro code. All it did was run the macro, but if there were locked fields or protect parts of the workbook, it disabled the spell checker all together. This code above was slick because...

got it. Thanks so much!

Thanks for your patience. how do you reference the current worksheet?

oops! I protect each worksheet differently on each page, I don't protect the workbook as a whole.

Sub button_spellcheck() Is this what I need? It doesn't seem to be working for me in Excel 2003 ' button_spellcheck Macro ' Macro recorded 9/13/2005 by Benjamin Shier ' ' ActiveWorkbook.Unprotect Range("B15,B12,B9,B6").Select Range("B6").Activate Selection.CheckSpelling...

So this is the code: Sub button_spellcheck() ' ' button_spellcheck Macro ' Macro recorded 9/13/2005 by Benjamin Shier ' ' Range("B15,B12,B9,B6").Select Range("B6").Activate Selection.CheckSpelling SpellLang:=1033 End Sub How do you write protect and unprotect in there? I tried...

I have form in excel. I have locked most of the cells except for the four on the page that I want the user to type into. I then want them to be able to spell check those four cells using a button. Problem: Though this works fine when the sheet is not protected, as soon as I protect the sheet...

Thanks for your help on this. This explanation helped me figure out a number of things I was working on. Thanks for your patience.

Thanks! I will play aroun with that. That might take care of it just fine. For my personal knowledge, any idea on the other part of my question? How to name cells as variables in vba?

I am trying to sort a page in excel. The trick is I want it to sort a range of cells that might change as new rows are added by the user. I am working off of the macro excel wrote when I started sorting. What I want to do is set the first cell of the range into a variable as well as the last...

I figured it out. Here is the code. Yesterday I think it was anotherhiggins who helped me with naming cells or a range of cells. This allowe me to select my named cell and insert a new record from there always adding it above my footer. the new row keeps my formatting from the above rows which...

What about something like what I thought anotherhiggins was suggesting, but a little different? Is there an easy way just to hide rows until required? So I have: A B C D Row1 Row2 Row3 Row4 Row5 (A5: Statement: =If B4 is blank, hide this row) Row6 (A6: Statement: =If B5 is...