Search results for query: *

Thanks Skip. I understand what you are saying. What I was hoping for was a way I could "trap" the event of a page break and then see if I am in the "range" of rows of the b1, b2, etc. The problem I have is that the number of b1, b2 and b3 may change as the user inserts rows. I did figure out...

Thanks Skip. Not sure I was clear onwhat I wanted. In my example I want the row heading of bbbbbbbbbbbbbbbbb to repeat for every b1, b2, b3 etc until I get to the row with ccccccccccccccccccccc. From what I understand, if I use the page setup and select bbbbbbbbbbbbbbb to repeat then when I...

I have an excel spreadsheet that has multiple sections. In one section (starting at row 13) the can be from 1 to n number of rows. The user can insert as many of these as they want. Following that is a different set of data. How do I repeat the row heading on the next page for the rows in...

Thanks to all who replied. The ON ERROR works perfectly. Rick

I've protected an excel sheet with a password. I know the old value and have successfully unprotected it to run some macro on the form. I now want to be able to change the password in vb from the old value to the new. How do I check the value of the current password to see if it's the old one...

Running the code to center across selection twice did not work either. Where I am using center across selection works under excel 2003 but not excel 2000. Also where I was right justifying the dates, that also does not appear to work. It keeps them left justified on excel 2000. Is there any...

works for me (excel 2003) but doesn't work in excel 2000. To export the code from my PC to another with 2000, I copy the macro to a word doc on a shared drive. The other PC user copies this and pastes over the previous macro in her personal.xls. Then runs the macro button for this. Same...

The results I am seeing are this: In the center across selection all the data does get stored in the first cell but it doesn't perform the center across selection. For the dates, the dates are left justified.

I have a macro that I recorded and used in my vb code. It does a center across selection for 3 continguous cells after "combining" the contents of all 3 cells into the first cell separated by a space. Then the values all but the first cell is deleted. The code works perfectly in excel 2003...

OK, here's the code I am using. I'm open to more efficient ways of doing this. Is there any way I can export this macro so it can be used in all the versions of this spreadsheet? Sub SetScheduleIndicator() Dim r As Integer Cells(5, 2).Value = "Green" r = 13 Do Until Cells(r, 6).Value =...

Tried to attach a document but couldn't get through my firewall here. I have a cell which is locked and calculated with forumula based on the difference between two other cells (dates) on the same row. The words green, yellow or red are inserted into the cell based on those other date cell...

I've seen that macro but what I need to do is 1st determine what the last row that has the background colors in it (there's other rows after that) and then use that as the ending row in a do loop. Hope that makes better sense.

New to VB macros. Need excel 2003 code to count the number of rows . I need to find last row and process all the rows in between. Beginning column/row is the same but the last row could change based on inserts. The values in the cells are background colors. If any are red I need to set an...

I tried a little of each and got it to work on multiple levels of group headers. Thanks!

I have 3 levels of group headers in my report. How do I eliminate printing them if there is no data for these levels?