Posts by ShosMeister

Re: Macro for placing numbers between two numbers in other sheet

Just change the RFI_No variable from an Integer to a String.

Re: Merge Multiple Sheets to one Master sheet

fixed

Re: Macro for placing numbers between two numbers in other sheet

Try this.

Re: Take elements from Dynamically Array for Select Case

As is being noted, a case statement needs a comparison. Consider it a different form of if/then.

Understand you don't know the values, but, what do you want to do when you do know it? Are you trying to ensure they are within certain parameters? Even numbers? Difference between two elements?

If you are trying to do something with each element individually without knowing how many there are, you'll need to run a loop around your select/case and evaluate each element based on the loop variable.

Re: Merge Multiple Sheets to one Master sheet

You need to provide just a bit more information. When do you want the master populated? Just once a month? Every day? Are there any calculation cells on the original sheets (your example is very sparse). What about duplicate data between multiple sheets? Copy all the entries?

Re: Take elements from Dynamically Array for Select Case

What are the values in the array and what are you trying to "Select" on? The value in the element or how many elements there are?

Re: Macro for placing numbers between two numbers in other sheet

Have you tried anything yet and are stuck/getting an error or are you wanting someone to do the entire program for you?

Re: how to retrieve the internet time and paste it in Excel

The link you provided does not accept (from what I can tell) requests for time. You'll probably have to look up one of the NIST sites and determine what the format of the requests needs to be in.

Re: Macro for combining all worksheets in a folder including subfolder and do a vlook

Can you upload a copy of the worksheet that has the code and error in it?

Re: Passing and Receiving Multidimensional arrays

Not sure but it appears you are trying to put array data into a non-array variable:

Dim DataArray As Variant

Re: automatically refresh workbook links every minute

Take a look at the RaiseEvent and Timer functions in Excel VBA.

Re: run macro only when cells are visible

There is a "Hidden" property of the range object you could test to see if the row/rows are visible or not.

Re: Copy and paste a value of 0 as a blank cell

Do you have a sample sheet you could attach? That would help.

Re: Populating sheets information into 2 sheets; 2 different ways, times, formats

While you provided a good explanation and a sample, you didn't indicate what part you were having trouble with. A copy of your current effort would be helpful.

Re: Open text files in excel separate in columns

Yes.

Re: Log external data to new column at X intervals

Not knowing how you are getting the data and putting into the sheet it's difficult to say exactly, but, simply moving the selection after you put the new data in should solve the problem.

Re: Dynamic Charts formulas.

I think you'll need to attach a sample file showing where the error is and your expected/desired results.

Re: Forecast final score using updates made at intervals of X minutes

Best I know is to use the forecast function of Excel. You say it isn't working but don't indicate if it's giving you an error or just not the expected value. Do you have an example worksheet clearly indicating the desired/expected result?

Re: dynamically add rows to a excel template

Did you want inline formulas or VBA? How are you importing the data from the database? Would it be easier to just create a data connection to the database from Excel?

Re: Hide message box when updating workbook, this workbooks contains links that canno

There is a preference/option that you can turn on/off for updating external links. Have you tried turning that off for this document?