option

Hello Excel Gurus, Simple question: is it possible to make x variable using the function above? or anything text or numbers that I want to declare. not working code Option Explicit Sub test() Dim x As String Debug.Print Evaluate("=CELL(""format"",x)") End Sub working code Option...

I have this string of VBA code in Sheet3(WIP), the first "Option Explicit" runs as written. The next VBA code runs as written However the bottom VBA code "Option Explicit" very similar but for reason it doesn't run as written, I get no error message. maybe there is a conflict with two VBA...

This code is periodically crashing excel when a user doesn't save a workbook. Sub FillLog(uName) Option Explicit uName = Environ("UserName") Sheets("Values").Cells(10, 43) = uName End Sub I ran the "Compile VBA Project" from the debug menu and it gave me an error or "invalid inside...

Is there an option to jump through a list on a worksheet alphabetically in Excel 2003?

I'm hoping someone can help me with splitting a column of data into six separate columns. I've tried using various functions with no luck, as the numbers can be different lengths, although each are separated by a forward slash. The "Text to Columns" feature isn't really an option as I'm hoping a...

Hello I would like the font on a command button to adapt to the amount of text. If the amount of text from Range("SeqName") is too much and the button is allowed to autosize, the button fills the entire width of the userform. I looked for a shrink to fit option, but no luck. Is there an option...

I have a series of 8 option buttons and 1 text box in a frame. Whichever button or text box is selected. Enter yes or result (text box) and the remaining will show N/A (They all have their own cell in a row on the worksheet. When I run the code now. I get True or False for the option buttons...

Sub mar() Dim IE As New SHDocVw.InternetExplorer IE.Visible = True IE.navigate "http://aicf.in/national-tournament-registration/" Do While IE.readyState <> 4 Loop IE.document.getElementById ("national_plr_payments_form") End Sub Help me to select...

Is it possible to highlight cells based on another cell. That is a bit of an oversimplification. My table looks something like this: <tbody> Choice 1 Choice 2 Choice 3 Choice 4 Choice 5 Choice 6 Option W Option X Option Y Option Z History Spanish Media RS PE Art History Spanish Art RS...

I have a very simple basic excel sheet where we store data. I have about six people that enter data and about 30 people that open the sheet just to get data. The problem is, the sheet is always open by someone and the 6 people can never enter data because it opens as read only. What's my best...

I have this code which activates when a cell on Sheet1 is changed. Suppose I double-clicked cell A1. Hovering the mouse over Target shows $A$1, as expected and the code runs through to teh function, without any problems. Option Explicit Private Sub Worksheet_Change(ByVal Target As...

I have broken out my pivot table by a filtered field so now I have numerous tabs. I want to be able to set Rows to repeat at top for all of these individual tabs but that option appears to be grayed out. Thoughts on how to accomplish this?

Option Explicit Dim fileloc As Long fileloc = "G:\Infection Control\CDRNE\CDRN Prism Data\MLVA data\IC RAW EXPORT TABLE" I want t use this fileloc string in several subsequent modules but I get an error message Compile error Invalid outside procedure Any ideas please

One of the most useful features of Excel for me is ignoring DDE links. It allows me to easily create multiple separate instances of excel that other users won't inadvertently try and open up their spreadsheets in (When running userforms etc). For some reason, I cannot get it to work properly...

Hello I've been trying to call a function and keep encountering a 'ByRef argument type mismatch' error. I can't see anything wrong with my code, and the only way I can get round it is by ensuring 'input' and 'output' variables (doubt if these are even real terms) are declared on separate...

I have several spreadsheets that require the 'Enable Iterative Calculation' to be selected in order to work correctly. Our business calcs require circular calculations on almost every sheet. Once I have this option checked, it stays active but only for me. It does not stay checked for my...

Hi, I have a formula as follows, which works fine. SUMIF('Overview report'!$AK:$AK,"Yes",'Overview report'!P:P) However, I also have a dropdown in cell O10 with a choice of seven values, and column AK in that formula is appropriate only for the first dropdown option. So if I have chosen the...

I need to combine a folder of several hundred CSV files (all in identical text formatting) into a single file. I don't have advanced computer knowledge so command line/macros aren't an option. I found that the professor excel add-on can do this pretty easily, but unfortunately, it doesn't work...

Hi All First time poster, and very new to excel, so please be kind. :) This may be a simple question for most of you, but as I'm relatively new to everything in excel bar basic formulas, I'm struggling. Been googling this for hours and can't find an answer (or don't know how to word in...

I am writing an Excel VBA code to fetch data from website. The displayed data is paginated and select option is given to display the number of records <select class="ui-paginator-rpp-options ui-widget ui-state-default ui-corner-left" value="20"> <option value="20"...