Posts by Newk222

Thanks! This was perfect!

I apologize again, but I forgot to mention that I have three files that use macros to open up and update this one file in particular. Your previous explaination would not allow that, would it?

I'm sorry....I really don't know much about Excel. Where would I find the workbook Open event?

I have one file that is fed from three other files. Other than those three files, I don't want anyone to be able to modify this file. These files are all on a network. Is there a way to save a file for read-only for all but those three files?

Never mind. Somehow the workbook was hidden. I have no idea how it got that way! have never seen that before.

Thank you anyways!

I created a file quite a while ago. It is on a network so other people can access it. I opened it today bt now I am trying to open it now, and something really weird is happening: it asks if I want to update macros, and I agree because it does have macros in it, but then the file isn't opened....its just a gray screen....it doesn't even have the file name at the top of the workbook.

Do you have any clue what is happening?

Its not like someone else is in the file because it would have told me it was "read only".

So, when I run the first macro (before the number of rows is deleted) could I count the number of rows that is in the named range and then assign that number to a variable. The second macro could then use the variable last saved by the first macro? or does it not work that way?

Something kinda like this...
where rngCopy is the named range

Dim NumRows as Integer

NumRows = Range(rngCopy).Rows.Count

Then have the second macro use NumRows....or would that always change because it uses the dynamic range in its formula. I really just want to somehow save the number of rows one time so people could undo what they previously copied, and then have that macro save a different number when the first macro is run again.

Thank you! I am very new will all of this so that is reassuring.

The problem is: is that my first macro deletes the entered data from that particular location after it copies it to another.

How would I define the global variable in my first macro before the "count gets deleted, and then use it in my second?

Lets say my range is "rngCopy"

and it refers to

=OFFSET(Data!G23,0,1,COUNTA(Data!G23:G7777),1)

Can a macro call a named range? (In this case it is a dynamic range because it always going to be changing.) If so, can it "store" that range (even just the number of rows would be fine) to later be called by a different macro?

I am creating a macro that copy and pastes two columns by how ever many rows of data is entered, but now I am trying to create another macro that would serve as an "undo" in case someone makes a mistake. I am aware that I would probably only be able to store the last entry, which is fine.

Thank you very much! That will be great. This may be a silly question but how do I get a new line in the text box? One of my definitions was two lines, but I hit enter and can not seem to make get the second line.

Here's basically what I am try to do:
I am making an alphabetized list (catalog) and each item in the list has an explaination to what it is. Because the list will be quite long, I want to hide the explaination of each. I also want to assign an option button to each, so if selected, the explaination with unhide. How do I get the explaination to re-hide if a different option button is selected?

an example is attached...

Oh I see now! Thank you!

That is the one that I was trying. But wouldn't the first point be at 47%, because 56/119 as a percent is 47. Yours looked the same way mine did. On our graphs that point was below the 40% line. I wasn't sure if there was a reason the percents weren't accurate.

oops...that wasn't right either.....I still need help with the first question. Here is an example:

Data 1
56 days

Data 2
6 days

Total Data
119 Days

I want three lines.... Total Days on top as 100%

then Data 1 to be right around 46% and Data 2 to be right around 5%.

(This is just an example of one point on the graph.....the rest of the points would follow similiar patters)

Nevermind! I had to change the series order!

I have two rows of data that I want to compare to a total row of data. The total is going to be the flat line across the top of the graph (100%) and I want the other two rows to each be their own line as a percentage of the total. But right now the bigger data numbers (row one) are showing up as a smaller percentage than the obviously smaller data number (row two), which doesn't make sense. Do I manually have to find the percentages of the total in order to graph them in this? way

Thank you! That was perfect!

I'm simply trying to average a row, but some of the cells contain "#DIV/0)!" (because it is a running file, so those have not been entered yet.....).....
How do I only average the cells with numbers in them?

I was trying

{=AVERAGE(IF((I9:T9<>#DIV/0!),I9:T9))}

(with the right command to make it an array)

Thanks....that's great!

Thanks that was great. Just a few questions:

If I don't need the message, and would just like to select that cell, how would I do that?