Search results for query: *

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

What I would like to do is program a button that inserts a new row (record) after the last row on the form instead of immediately above the row.

Interesting. anotherhiggins has an interesting thought I might play with. But what I have is an activities sheet. It asks for the same information over and over again on each row, A through G. Right now I give them about enough rows to fill a printed page. When they get down to the last row...

I want a button that inserts a new row at the bottom when they have finished up with the available rows. So far though the insert button when recording a macro adds it above the selected record. Also, when repeated, it does the action off of the record that you origonally selected which pretty...

I think that is exactly what it was. It was thinking it was a header. I used a "follow my actions" macro and it wrote in there a "header:=xlGuess". So for whatever reason initially it seemed to work. but then after that it seemed to do it wrong. So now it is set to no. Thanks for the help.

Weird, I have a list of names in a column that I want to sort alphabetically. When I try to sort, it leaves the top value selected and sorts all those below it. I am working with vba taking the values elsewhere once sorted, but it should affect this part of it. Any idea why the top value remains...