Search results

Will this in a Macro by itself, unhide everything or show all the rows? rows("3:1971").entirerow.hidden = False Yeah. Sometimes I may need to look at the data different ways for different reasons...I'm working thru this for my boss. These are different questions that he had. In this...

Thanks so much for the explanation. I am going to sit down and go over it really well to understand exactly what the Macro is doing. When I asked my 2nd question about starting the comment with default information, I used the term default headings. I didn't mean the headings for the Columns...

Yeah we must of working at the same time. If I look at it long enough and poke around, I can normally figure a lot out on my own. I did change the range from the new code, otherwise, this is what I ended up with: Sub hide_row() Dim ws As Worksheet Dim rng As Range Set ws =...

This is really new to me so I am trying to work through it for each rng in ws.range("a1", ws.range("A" & ws.rows.count).end(xlup)) if rng.value < rng.offset(0,1).value then The you say change the range this is what I am assuming: "for each rng in ws.range("I3", ws.range("I" &...

OK...The columns I am using are "I" and "J". If "J" is 50% of "I" or more then I want to hide that Row. So if J*.50 is greater than I, Hide the current Row. I am checking Rows 3-1971. How would I work this into the Macro? Bob

The headings are stored in Rows 1 & 2. We have them split into the two rows to keep them more narrow. If necessary we could put them into one row. Bob

Just wanted to thank you again for your help. This is the first Macro we have successfully completed. If you wouldn't mind, could you write me a brief description on each line, explaining exactly what it is doing. I am trying to get a better understanding of Macros. It is still very new to...

After I posted the first message I just looked around a little more and checked out the help and kind of found my way around. Sub Com_box() Call Com_size(ActiveCell, 12, 15) 'change the '1000' and '999' based on what size you want 1000 is the width 999 the height End Sub Sub Com_size(rng...

After I posted I read over your message again... I made the following change in the code: Sub Com_box() Call Com_size(ActiveCell, 12, 15) 'change the '1000' and '999' based on what size you want 1000 is the width 999 the height End Sub Sub Com_size(rng As Range, x As Long, y As Long)...

I haven't tried linking the sub to a button yet...This is what I have done so far: Sub Com_box() Call Com_box(ActiveCell, 12, 15) 'change the '1000' and '999' based on what size you want 1000 is the width 999 the height End Sub Sub Com_box(rng As Range, x As Long, y As Long) Dim cmmt As...

Is there a place to change the default opening size of the Insert Comments box? Bob

I have a spread sheet with many rows. It was 12 columns. Two columns have a number in them. I want to hide rowes based on the two numberd columns. Example: if column A is 45 and B is 65 hide A A<B Hide the row that these values come from. Bob

namliam Thanks for te help Bob

I'm trying to add a time of 1:30 (One Hour and 30 minutes) to a Number with 2 decimal places (1.50 which is 1 hour and 30 minutes). I'm not having much luck. I also want to concider using a number that might be 57 (57 minutes). Bob

I have two cells formated to TIME 1:30 PM. I have a column that has start times. Another with finish times. A1 = Start B1 = Finish My natural thought is =a1-b1 would give me my total time for the day. Wrong I am. What do I need to do? Bob

I have data in a spreadsheet (Excel 2007). The data is by the years 2004-2009(columns) and also January - December (rows). I have all the data for 2004-2008. In 2009 I only have data for January - June. How can I speculate or forecast what the values will be for July through December? I...

Thank you so much for your help. This is our first Excel Macro; thanks to you. I used to work in Quattro Pro years ago...I was able to build some pretty complex macros and calculations there. Thanks again, Bob

I see what you are doing. I am going to try to explain myself a little better. I do understand what you are doing and I see how it works. I would like to set the Macro to Hide every other column. Here are the points: File Name is FULL_11_Bob.xlsx I want to hide columns: D, F, H, J, L etc...

Thanks for the quick responce. I did just try this and got an error. Run-Time error '28': Out of stack space. Seems like an error I would get years ago. Sub Hide() ' ' Hide Macro ' Auto hide Columns ' ' Keyboard Shortcut: Ctrl+p ' Application.Run "FULL_11_Bob2.xlsx!Hide"...

I would like to Hide columns a,b,c,d by clicking on a cell that containes the commands to do so. Years in past I had Quatropro that did that for me. I'm just starting with Excell. So if you told me to use a macro, I would not have a clue. I was hoping to see the actuall macro to get me started...