subscript

What is wrong with the following? I get a Run-time error '9', subscript out of range error. Workbooks.Open "C:\Files\MyWorkbook.xlsx" Dim a As Long a = Workbooks("C:\Files\MyWorkbook.xlsx").Worksheets.Count Thanks

Hi I'm trying to activate a macro enabled file called "Test" that I saved to my desktop. However, I get a "Run time error: 9 Subscript out of range" - the file is open, so just needs to be activated. Please can you help? Workbooks("\Test file.xlsm").ActivateWorkbooks("\Test...

Hi I get the error Subscript out of range in the below code. What is wrong with it? Thank you Option Explicit Sub test() Dim i As Integer For i = 1 To 6 ThisWorkbook.Worksheets(1).Cells(i, 1).Value = Workbooks(2).Worksheets(i).Name Next End Sub

Hi there, pretty new to macros and VBA, but I'm fairly confident this is strange behaviour. I wrote a little macro to toggle the last letter of the selected cell to superscript, to help make m^2 easier to format. I've pasted it below and it works perfectly. Only thing is, I went to do the same...

Hello Everyone., I'm new to this forum. :) I'm having some trouble running a macro from my personal workbook. I created a macro in another workbook ("Report1") but saved it to my personal workbook. When I run the run macro in a different workbook ("Report2"), I get a run time error 9 message...

Hi all, I am seeing a strange error when running a simple line of VBA code. When I personally run the VBA macro I do NOT get the error message but when my colleague runs the VBA macro they get the "subscript out of range" error. The line of code causing this is the following. Dim...

Hi, I'm currently trying to write a VBA code, it looks like this: Dim currentTopPos1 As Long Private Sub cmdSaveData1_Click() Dim settings As Variant Dim info() As String Dim index As Long With Sheets(sheet_settings1) ReDim info(1 To getLR1(.Name, "A") - 1)...

I have a document that is basically a big Table of Contents, with hyperlinks to helpful sites. I have 2 macros- the first is basically a keyword search, that hides all rows that don't include the keyword that the user enters into cell H2. The second is a simple command to unhide all of the...

Hi all, I have a particular problem that I need help with. I have a spreadsheet with numerous equations that have been either typed into a cell or created using "insert-->equation". A lot of these equations have many subscripts and superscripts. My problem is that I want a cell to return a...

Hi all! I have this problem trying to print multiple sheets in a single pdf. Browsing online and in the forum i found this code but when i use it i get the ERROR 9 "Subscript out of range" and i dont understand why. I tried in a new workbook the code and it works properly. Can someone help...

The task here is rather simple: Make all the numbers in all the cells in the selected range go to subscript, and all the others to lose the subscript. The code works brilliantly when the original text has no subscripts or if all the characters in the cells are in subscript. When some of the...

Hi, I'm creating a userform that allows a user to generate figures with a push of a button. The data is pulled through onto labels with the corresponding name. I can get this to work with the Data Source open. However, I do not want the Data Source to be open, so I tried the following code...

I would like to write $14 in a cell with the $ as regular character and the 14 as subscript (meaning money of year 2014). The $14 is obtained using the following code ="$"&ref_year-2000 where ref_year= 2014. Is this doable in Excel or do I need VBA? Thanks.

Hi All, I pasted data from a PDF into an excel table and the subscripts copied over as whole numbers. This is how the data looks in the PDF 2222 However, it reads in Excel as 2222 Is there a way to remove these subscripts, perhaps with a macro The subscripted # varies as does number...

I keep getting an error message saying subscript out of range with this code. Sub Check_First() Dim Z As Integer Z = 1 Do While Z <= Range("o1").Value Range("r1").Value = Z Range("AH2").Select Range("A2:AJ2").Select Selection.AutoFilter Selection.AutoFilter...

I do a lot of spreadsheets where I type certainl chemical formulas over and over (CO2, H2O, CH4, N2O). When I finalize the report I am having to go into each instance and manually subscripting the number which takes forever. I am aware of a way to use autocorrect where I can type in something...

I know that a cell has to be in the text format to be able to subscript the value. Here is my issue: I have an excel workbook that sheet 1 pulls a value from sheet 2. The value in sheet 1 needs to have a subscript $ sign on it. If I make it a text format the only thing that shows up is the...

Hi I’m having a lot of trouble with a sentence of my code because it’s returning a subscript out of range error, what my code is trying to do is filtering the data, base on the user input and if the word exists then show that in the lisbox, if not, show a message to the user, I’m sure there is...

basically, I have a main data dump sheet named ContestReport. I'd like to create sheets based on Culumn B (minus the header) and then copy the row to the appropriate sheet based on the value of B. This is correctly creating the sheets, but I'm running into an error with the copying and I am...

Hi, I never noticed that sub/superscript characters couldn't be displayed on userform captions until this was raised on this forum the other day. here is a little hack that i've managed to put together to simulate sub/superscrips via subclassing the userform.I am hoping this could be...