Search results for query: *

Greetings one and all, This one has been bothering me for awhile and Microsoft hasn't been any help. I have code to open a workbook, however due to the known bug in Excel sometimes the code simply stops when the workbook is opened. Microsofts patch (below) deals with the shift key and isn't...

This is a new one for me and something that was just discovered with our main workbook. Worksheets will sometimes get copied over to the main workbook. However this can create names in the name manager and recording a macro didn't offer any light on how to remove all the names. Since I don't...

I am trying to set up a page so that when it is printed the print area is preset. So far I have found ways to print the selection and toyed with Workbook_BeforePrint, but have not found a way to preset the selection area for the user. Given the amount of printing, setting the print area is...

Are there any known coding reasons why a footer in Excel would not update properly for printing? The code for the footers is created in a separate macro, and the workbook can be closed and re-opened and the footers will show up on print preview and print correctly for the first few. Up to ten...

I have an Excel workbook that the footers are acting goofy when printing. When I first open the workbook the footers will show up on the print preview and print correctly for a handful of sheets, however if I select several sheets to print the footer doesn't up date properly and will print with...

I have some old code to do this but its crude and slow. In a folder are over 400 workbooks and each of the workbooks has tabs that start with io. I need to get into each workbook, find the right tab, pull the info from a set of cells and then close the workbook and repeat. Because the...

Greetings, I am trying to get some very basic information on how to link AutoCAD LT to Excel. I know VBA fairly well but have never worked with AutoCAD before. What I need to do is three separate things - 1 - Update a template from Excel. 2 - Put and Get text from a drawing based on an...

Does anyone know how, or can anyone point me in the direction of how, to link AutoCAD LT to Excel? I would like to populate some templates with information and pull / put information from drawings. So far all I find online is a hodge podge of various information non-relevant information about...

I can't figure this one out. I have three different sets of code that is simply to center text in cells. When either of the first two are run in the sub or the immediate window it doesn't work and returns null. ?ThisWorkbook.Sheets("Grouping").Cells.HorizontalAlignment = xlCenter Null...

I am having a problem with the workbook wanting to use a popup window each time a link is updated instead of it auto updating using this line of code: ThisWorkbook.UpdateLink Name:=ThisWorkbook.LinkSources Anyone know why and how to update the formulas without the annoying popups making...

So on this project I have been working on I am doing final testing and started having a new issue with the formulas placed into the worksheets not updating. I can't figure out why they won't update and have tried a fairly wide range of solutions including Application.Update...

I have a sub that calls another sub. The problem is that when the second sub is called it doesn't work properly for the final few lines but if I run it separately it corrects itself and is just fine. Why? It has taken me a while to make sense of what I hear at work involving computers. There...

I am having problems with this sub and its probably something obvious. The purpose is to capture the last three numbers on the worksheets and list them on a worksheet called INFO in descending order in column B. Whats wrong? Public WS As Worksheet Public A As Integer Sub Get_Number()...

I am running into two separate issues that happen about the same time. First I have to find a way to adjust where information is put on an excel sheet for specific sequences of a loop. For example, if the desired cell for all iterations is D24 thats fine, but if there is a specific condition...

Is there a way to do a select statement with an OR? Example - Select Case Left(CB_SINGLE_TextBox1, 1) <> "8" Or Left(IO_Single_TextBox1, 1) <> "8" It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid...

Does select case not like <> ? Example Case is <> 2,3 It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid. Therefore I have come to the logical conclusion that the only way to have a properly functioning...

This formula has ceased to work for some reason: Test is a variable that holds the total number of rows with information below the header row. B is the starting row for the loop - in this case 5. C is the column which is 44 for this instance. Sheets("Info").Cells(B, C + 1).Formula = _...

Does anyone know the max number of OR operators that can be in the same line of code? I haven't found anything to state if there are or are not limits.

Why am I getting an error on line 100? The array is used in other subs without any problems and works fine everywhere else. Sub New_Output_Array() Dim RELAY As Boolean On Error GoTo Error_Handler 100: Erase IO_OUTPUT_ARRAY 200: Erase RELAY_ARRAY 300: TEST = 1 400: COUNTER = 1...

Can anyone tell me why the code below will produce incorrect results? Code: For A = 0 To COUNTER ReDim Preserve IO_Array(D) IO_Array(D) = Sheets("io" & Temp_Nmbr).Cells(B, C).Value D = D + 1 ReDim Preserve IO_Array(D) IO_Array(D) = Sheets("io" & Temp_Nmbr).Cells(B, C +...