continue

Hello, I have a sheet that gets it's data from a database connection. Now i'm at the end of the rows (nr. 1048576). How can I continue using the sheet without having to delete data? Thank you.

I'm trying to add a graph representing a target figure, however I want the graph to be a shape e.g. thermometer; that would continue to fill as you get closer to target figure? Any help appreciated. Thanks

Guys, good afternoon! when you log in via vba excel on the page, you open a form in .asp, the macro does not continue, it stops waiting for the form to close. I need the macro to continue ... Can you help me?</pre>

Hi everyone, I am trying to get the area highlighted in yellow to appear and refresh automatically when adding more data as I continue to add data in the future, while also not copying any blank spaces. https://imgur.com/cf6kvJu Is there a way to do this with a formula?

Hi I'm looking for a VBA code to solve the problem below, the input will start in Cell I2. I'd really appreciate any help on this. Raw input table: <tbody> A B C D E F G H I J K L M N O P Q R 1 2 2000 2001 2002 2003 2000 2001 2002 2003 ... to continue up to 30...

I have a cell where I am trying to determine a multiplier from 0 to 1 in column A to then be used to scale a value in column B that produces another value in column C. However if column C is greater than zero the multiplier must be reduced until column C is zero (i.e if column C is zero I want...

HI Everyone, I need the code for a message box that gives the person 3 options when run the message box needs to say "You have not Submited Data Yet" new line " What would you like to do? Then if possible give the options of "Cancel" "Submit & Continue" "Continue" if cancel just come...

hi, I created a worksheet. Before others can use this worksheet for data entry. They must fill specific cell as below at first place. Than continue entering data. If not, they are not able to continue their work. 1. B3 2. D3 3. F3. How do i can do this. thank you

When using Sort (and a couple other commands) a dialog box will pop up, the "Sort Warning", and ask you what you want to do? It then gives you 2 options "Expand the selection" and "Continue with the current selection" and by default it starts on expand the selection. So my question is whether or...

Hi can anyone help with vba code? I have a Sub named 'My Data' I have values in cells D3 and D4 Sheet2 and want to call a Sub named 'DataValues' then exit sub but only when D3 = D4 greater than -1 eg (A) - if D3 value is 1 and D4 value is 3 then I want Sub 'My Data' to call Sub 'DataValues'...

Hello, I've been searching the forum to help me with my problem. I've managed to put a code together using the tips I have found on the forum. However, if I continue working the message keeps popping up. How do I make it stop? Thanks in advance. Private Sub Worksheet_Change(ByVal Target As...

In cell A1 is 100, in cell A2 is 2. So what I would like to do in cell A3 would be to add 1 to A1 cell 100 = 101, then in cell A4 add 2 to A1 cell 100 = 102. But if cell A2 was 4. I would like to continue to add 1 a further 2 times so cell A5 would = 103 and cell A6 would = 104. Thank you

Good afternoon Trying to insert the worksheet.Function.Average for a specific range of rows "A2:A9" for columns 5 then "A2:A9 in column 6 and so on. Then there are columns 11 to 14 where I do not wish to insert any average and continue on with columns 15 to 19. Thank You

Good afternoon. I have been trying to find a workaround for this, and am at the point of pulling my hair out. I have what I consider to be a very simple macro. All it does is refresh a number of connections that are in my excel file. All of these connections are to the same access database. The...

Hello, I have a sheet that refers to another sheet with a formula, =IF(StartHereSubCom!A8>"",StartHereSubCom!A8,"") If I delete row 8 on the other sheet it does this.= IF(StartHereSubCom!#REF!>"",StartHereSubCom!#REF!,"") How do I make it continue to look at cell A8? Any help would be...

I would like to direct, by way of a MsgBox, the user to select a pull-down cell and obtain a selection and then continue the program operation. How and what VBE coding will accomplish this?

What can I add to this formula in Excel to tell it when it fills up range B4:B14 on COMPOSIT PG 1 to continue down the same range in COMPOSITE PG2? =IFERROR(IF(C2="Table Row",MATCH(SpecNo,Table2[LYB Spec],0),IF(MATCH(SpecNo,Table2[LYB Spec],0)+COUNTIF(Table2[LYB Spec],SpecNo)...

Running Office Home and Student 2016 I have a spreadsheet in which months ago I locked (froze?) the top few rows so they'd stay visible as I scrolled down. Now I'd like to add some rows to that and I can find no way to do this. The Freeze Pane icon is grayed out. The workbook is NOT...

I have a macro that formats data and I would like one check for a value. If the value in the sheet called "QualityCheck" Cell c15 is less than 25, then create an alert message "value is less than 25 - verify inputs". They can then click "OK" and the macro should continue on. Can I get a...

Hello there - I am having difficulties with handling IE errors to prevent manual intervention when a webpage throws an error. My code to engage IE is: 'ASSIGN ARRAY POSITION USING IE(Counter) Set IE(CounterMax) = GetObject("new:{D5E8041D-920F-45e9-B8FB-B1DEB82C6E5E}")...