inside

I currently have hyperlinks (within a large number of cells) that link to places within the same document, but the cell sizes are, by necessity, quite small, and the hyperlinked letter inside each of the cells is even smaller, therefore very hard to click on quickly ... usually I'll miss the...

I made a formula which consists of multiple IFERRORs with LOOKUPs and INDEX MATCHes. Basically, if th formula doesn't find the info, look it up on another workbook. The thing is... Inside the third (the last) IFERROR, the "value_if_error" part returns an information, if I press the F9 key on it...

Hi, I am trying to copy the range of cells inside for loop. My intention to copy Range("N" & i to "U" & i) For this, I have written below code but the compiler is not happy with it. Any help, please. For i = 6 to 100 Range("N" & i : "U" & i).Copy Next i

Hello all This piece of code checks to see if a folder with the value "MyContact" exists and if not creates a folder on my S Drive with the folder with the value of "MyContact" It then saves the active sheet in this folder with the value from "MyFileName and "Mydate" sDir =...

On my form I have a textbox1 control and this code In Form Activate action2 Me.TextBox1, "fred" Sub action2(tb As TextBox, tt As String) tb.Text = tt End Sub I've tried various things, Inside quotes, with & without "Me" but keep getting Type Mismatch errors. I can't see why this...

I have a few simple list boxes, one showing a list of vendors and the other showing a list of months. Every time I save and exit the workbook, the list boxes shrink from the bottom so when I reopen said workbook, some of the options inside the boxes are not visible. How can I get these list...

Hi, To the file below, why can't I run the macro inside it? https://1drv.ms/x/s!Ai8CrEskdewXm1EtunChN-NFqXkj

<tbody> AMOUNT 1 AMOUNT 2 220000 154 153000 1001 74000 2521 756349 3256 122000 4566 856746 1566 444352 816 212158 612 346777 315 </tbody> Hi all, I need a little help with a matrix and formulas inside. I have 2 columns - AMOUNT 1 and AMOUNT 2 and I need...

How to use variables inside activecell.formular1c1?

Hi I wanted to know if there is a formula to average the cells from D5 to D9 if value is inside. So lets say D5 D6 D7 have values 100 50 50. Then it would divide the total 200 into 3, but if Value was in all cells D5 D6 D7 D8 D9 like 100 50 50 40 and 30. Then it would divide it into 5. Any...

Hello, In vba, is there a way to use "application.worksheetfunction.min()" to find the minimum of a vector Inside a matrix. Exemple Data(1 to 3, 1 to 20) as variant Inside my Data(1,: ) i have dates. I would like to easily find the minimum date. Thank you!

Hi All, I am trying to teach myself VBA. I have created some examples that I am trying to solve but I have no actual need to complete these tasks (other than to learn the code itself). With that said, what I am trying to do in this example is create a macro that inserts a spin button in each...

Please guys I need your help with this formula. I don't know how to solve it. The issue is that: I am using this formula: If(ISNUMBER(FIND$F93;H1);$G93;0) The problem is that this formula is used in a long line, changing the H1. H1=0, I1=1, J1=2, K1=3 and so on until 120. So, the issue is...

Hi What is the idea of having Range object inside Range Object? Thank you so much.

Hi I just want to hear your opinion about this. Worksheet object has a function called SaveAs! that function will actually save the workbook as whatever_name_you_pass.xlsxm. My question, why we have that function inside Worksheet? We have similar function inside Workbook and there it makes more...

For my workbook, I want a 'splash screen' to display immediately after the workbook has been opened. The workbook takes a 10-12 seconds to run a bunch of code when it is first opened, so I want to inform the user that the workbook is loading, so they don't think something is wrong. I created a...

Hi and thanks in advance! If I wanna know the Week Number of a quarter, I can use, the formula: The Dates are in Column D =WEEKNUM(D3;1)-WEEKNUM((LOOKUP(D3;DATE(YEAR(D3);{2;5;8;11};1)));1)+1 But in my company the first quarter stars the 1st of november, the 2nd quarter the 1st of february...

Hello Guys! I'm currently working on a worksheet and i need help on the formula. Im trying to get the guest count from the long list given to me in an excel sheet where name of guest and head count is written together in 1 cell and in a single column. 1) I would like to get the sum of all the...

Hi All i have a list of OR conditions that need to be met before returning a value ie =if(or(a1=“test1”,a1=“test2”,a1=“test3”)...etc rather than having to change the values inside the cell if the or conditions was to grow, how can I look it up in a range ie...

Hello Looking for some help. I'm trying to find the row value of a specific text that appears inside a range. Once I have this row, I'll need to copy the data that is located 3 columns to the left of this same row. I have placed the search text inside a cell and if that do not work, I need...