Search results for query: *

mintjulep First I want to thank you for being so understanding with me & not giving me the answer, but making me hunt. I researched my work sheet, & I had used a an array, but did not understand it. A friend gave me the formula, but did not explain it. her is a short version of the formula...

Answer 1. K7 is cell that generates the quantity from the raw data, I7 is the cell that generates the month from the raw data. The 4 is a static number I entered. Answer 2. Row(Indirect(“1:10”)) formula is one that I was playing with to understand arrays. I know that there is a lot I don't...

Thanks for pointing me in the right direction. I have a better understanding about single cell arrays, with a number range. I do understand that arrays will show the first number in the array. I am still struggling about how to combine this simple array formula =ROW(INDIRECT("1:10")), with my...

I have a formula that counts a size value & quantity for a certain month. I7 is the month cell, K7 is the quantity value for the size. The following formula works if the cell value is static. =COUNTIFS(K7,"4",I7,10)*K7 Is it possible to have a range of numbers in the formula from 1 to 100? I...

Agreed. Prior to working with code, I was using formulas. I just adapted what I had started with, rather do over. The old saying "If I had known then, what I know now", I would have done things differently.

what happens to rows 2 & 3??? Nothing, this is used to search only 1 column. Why wouldn't this table have a header??? Must tables do have headers, But I was trying to allow for the rare occasion when there was no header. This range is on VOC_ASST, is it not? Correct. It is.

yes. It went down several rows where I had raw data.

Skip. A big Keystone Thank You to you for your help. [thumbsup2] [thumbsup2] I did take your advice & change from select to.... I did try your suggestion for locating the next blank cell, however it went several rows past the last row in the table. I worked on the code & came up with the...

Currently I have basic code to go to another sheet in the current work & code to find the first blank cell on a worksheet. I am trying to combine the two codes, so when selected it goes to the first blank cell on another sheet. Here is the code to go to another sheet it is located on the "TOC"...

This is an update to the problem. It happens sporadically, so I will just have live with the issue. Thanks for your help.

I just learned something just now. The problem is only with one workbook. I am getting the impression that I may just have to live with the problem.

Yes. There was no change. I did it on the home page (TOC).

Strangely nothing.

Just one workbook is saved at a time. The procedures were added at user requests. I did look at what you mentioned prior to coming up with the current code. The code just started acting stupid recently. Up till last week there were no issues

I failed to mention that the normal save request comes up. If there has been new data entered, then save chosen & the data saved. TOC is used when excel is exited from any sheet other than TOC (Table of Contents). TOC is the home page for that particular excel app, & with multiple users, you...

I am currently using VBA code to close excel, rather than several steps. Originally the code worked as expected. Now it closes but gives this error code. "Microsoft Excel has stopped working. A problem caused the program to stop working correctly. Please close the program. Here is the current...

I want to thank Skip & Andrzejek for your assistance. I learned several things in this process, one is that you don't give up. The other thing is that occasionally an old school person like me can find a solution to a problem. Here is the code: Sub VISTA() Dim Msg As String, Ans As Variant...

Oh. So if I understand you, it should be Public oSystem As "Something"System. etc.

Skip. Right now, I am so certain what you mean. I did check the object name & it is "C:\ProgramData\Attachmate\Reflection\R04-reflection.r2w" I am guessing that it has something to do with the object name, but I have no idea. I am providing the following info, in the hope that it may hep us...

I am not quite certain how to do that. Coding is something that you young guys find easy. An old person like myself (63) still struggle with coding. Please point me in the right direction. I checked & there was no reference to the Attachmate Reflections Object Library. I did add a reference to...