setting

If you receive a workbook where the document was created with an undesirable default Font/Size, what can be done to change it, other than editing the documents XML? Setting the Font/Size for headers is done under: File\Options\General... When creating new workbooks Make it a nightmare by...

A friend is setting up a discussion forum and he is looking for a way to rank the users according to post count. For example: 0-10 posts: rookie 11-49: beginner etc etc etc Any ideas?

When I use "Find" to search for a certain dollar amount in a spreadsheet, and I know that what I'm searching for is in that spreadsheet, it won't find that dollar amount. In the options box, the default setting is "Formulas" and I have to change it to "Values". Is there a way to make the...

often I will clear a cells value with an if statement =if(condition) then, "Action",""). My issue is with the "". Instead of setting the cell to "" how to I just make it a blank cell?

Column A contains a list of dates, starting at row 21. I don't know without looking how many there will be, but it won't be more than a few hundred. lRow = WorksheetFunction.Match(dDate, .Range("A21:A1000"), 0) is supposed to give me the row of dDate if it exists in the column or an error if...

I have a file and am looking in column E and G. If Column E="Bob's" and column G="1234", I'd like a message to pop up stating "abc". How do I write this. I have the code below, but that only looks at individual columns. Sub Bob's() If Range("E3:E30").Value = "Bob's" Then MsgBox "If this Bob's...

Hi, I am looking at a spreadsheet provided by a colleague. It appears to have restricted the column's viewable. So I can only scroll over to column AH, and then it just ends. This must be a setting, it is not like the extra columns are hidden. Does anyone know how to alter these settings...

Hi! I have a code, with this part in the "Thisworkbook" module: Set rw = ws.Range("A:A").Find(Cells(Target.Row, 1).Value, , xlValues, LookAt:=xlWhole) And after it runs, the "Find" tab saves it as setting and search for xlWhole, so I have to set it back every time manually to xlPart. (If I add...

I created a DAX measure on Excel 2016 and right click edit the number formatting option is quite limited. For example, for negative if I wish to display (1,234) that seems not an option but instead only -1,234 is possible. Is there an alternative way we can achieve a custom formatting on it ...

How can I do this? rg = Left(a1, 6) If rg = "OR0020" Then GoTo OR0020 If rg = "OR0025" Then GoTo OR0025

Parameters Path DCI_SIMPLE_APP_CONTROL_WORD Category 1/Sample App DCI_SIMPLE_APP_STATUS_WORD Category 1/Sample App DCI_BLE_TEST_SETTING_1 Category 1 DCI_BLE_TEST_SETTING_A...

Hello everyone, I am having a random issue with Excel. Usually, in order to copy visible cells only I'd have to use Alt + ;. Now, it seems to be doing this automatically. Is this a setting I've inadvertently enabled, has Microsoft done an update, or am I just crazy? Thank you.

Hi, I have noticed when I use the range as a data source it seems to stop working after so many row. On looking online it seems that the best way is to put it as a string. I am setting the string as PRange = Source & "!A1:B" & LastRow Which Generates "Database Data!A1:B70000" I am then...

I have a VBA script in an excel file that will generate an email. My problem is setting the font in the email. This code works: strbody = "****** style=font-size:11pt;font-family:Arial>Hello.</BODY>" This code does not work: strbody = "****** style=font-size:11pt;font-family:Segoe UI...

Hi excel gurus, Just wondering if someone could help me out please. I want to create a validated list where if someone chooses and option from the list it uses a formula that adds the next row number to the end of the formula. So for example my list option would be "alarm on and next step". The...

For all the CHAR values from 129 onwards I am getting a question mark (?) returned rather than the character set value. Is there a setting that has stopped this working? TIA

Hi, I have a procedure that set / reset the pattern of the currently selected cell which work fine but I would like to set the pattern color too so I added the line in blue: Public Sub SetReset_Pattern(thePattern, patternColorIndex) With ActiveSheet If Selection.Interior.Pattern =...

Good afternoon all, I'm having some trouble setting an array item to the value of cell. How can this be done? Currently I'm working with this: Dim ArrayName() As Variant ArrayName(row no., column no.) = Range(column letter & row number).Offset(0, -1).Value ' I want the value of the cell...

In my ongoing quest to optimize my laggy file, I've read that even if cells don't have overly complex formulas, repainting their contents (when calculations are running often, which is the case for me since I'm streaming in real-time stock data) is surprisingly resource-intensive. Simple Q: if...

I have lost the setting to print 8.5 x 14 sheets ! how do I recover this setting ? THANKS