size

Is there a way to attach either an Excel file or a jpg a thread? What is the size limitations?

Hi All, I was unable to find a reference to this, but I'm trying to use INDEX/MATCH to return the first non-blank result like but due to the size of data, I can't use an array... Any ideas?

Hello All, I have an excel-vba userform that has some checkboxes, lables and buttons. I have given the specific height and width for the form which is almost 3/4 th size of my Screen. This form is used by my colleagues with different Screen resolutions. For few of my colleagues, the form is too...

Is there a way, like creating a template, that will default to"do not move or size" shapes"?

Hi there, I hope this message finds you all well and in finc spirits today ;-) I'm trying to set up some macro buttons (ie a shape with a macro assigned to it) at the top of an Excel worksheet. This 'top' are ten rows which are 'Grouped' and typically collapsed when using the worksheet (i...

Hello, I was thinking about the VBA macro for exporting a range from Excel to Word document. Following macro seems to be doing it, although I have a problem with the pasted size. The data copied from Excel is too big for a Word document. Is there any way to adjust the copy/paste size, so copied...

I'm 99% you can't make a toggle button using code, so can you change the size and location of one via code? I have a few on a sheet and they seem to have resized/relocated on their own when switch computers and it's quite annoying so I was just going to have code (if possible) to ensure they...

i tried recording this macro but its giving me an error on the highlighted line, can anyone help Sub fxgxfbcfb() ' ' fxgxfbcfb Macro ' ' Keyboard Shortcut: Ctrl+Shift+F ' Application.CutCopyMode = False ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _...

I've created a expense report with a check box (form control) to indicate if paid for with company credit card. When printing the expense report the check box shrinks to almost unreadable. I do have it custom scaled to print all columns on one page. Is there a way to print without changing the...

Dear All, I have been trying to work on this VBA question: You must now create a user-defined function that will take two parameters of type range (two matrices mat1 and mat2). The function returns a matrix C in which each element is equal to the max value with the same coordinates in mat1...

Hello everyone, i have this problem i have to solve. It's not that easy but here it is .... In column A i have a list of sizes maybe Hundreds Thousands.. and they might be from 10 to 100 in column B. i also have a certain target range for example 95 to 100. i want to add all numbers in column B...

Hi all I would like to enter a value in a cell and have the 2 cells above and the 2 cells below all merge and increase the font size to 24 in bold. Example: A value is entered in A3. A1:A5 is merged. Font size increases to 24 in bold. Possible? Thank you! Russ

Hi Everyone, I have used "picture link" to paste the data(in sheet2) from my worksheet(sheet1) And I resize that picture to bigger. After that I copy sheet2 to sheet3, sheet4 and sheet5. The picture'size (from "picture link") is equal size of worksheet(sheet1) How can I resize "picture...

I am making a spreadsheet that is a fortnightly timesheet. It has an active x textbox for each day in the fortnight. I want to be able to change the font size of some lines within the text boxes. Is there a simple way to do this like a button that increases the font size by 1 level with the...

Hello and thank you in advance if you can help, I am using Access 2019 on a PC. I have a database that under properties is said to have a size of 2.87 MB. All my files are linked, four data files as text imports (two 1 million + records, and the other two small, a few thousand), 8 lookup...

<tbody> Good day. this formula works in the same workbook. =VLOOKUP($B$2,INDIRECT("'"&$A7&"'!$A:$DB"),75,FALSE) but when i use it with different workbook is not working. SUMMARY WORKBOOK <tbody> Stock Code SHOES1 (input code) Description GIGASHOES (=VLOOKUP(B2,Sheet10)!A:F,2,FALSE)...

Hi, I have a shape that contains text, what I need is to change the font size of any text between "()". How can I do that? I was able to write below macro and it worked, however, the characters might change in future and I need to update below macro to cover this: Sub Change_Font_Size()...

I've recently tried to make a switch towards using for loops as opposed to just writing out all the code but I have run into an issue when using an array to sort rows based on an array value. I have a table containing all the worksheet names and variables I wish to sort by. The data that needs...

Hello everyone, I am working to create a Powerpoint that has many linked cells from an Excel workbook (like 100+). Whenever I click "update links" when opening the PowerPoint, the cells all shift slightly and they also cut off so you can only read half of the cell. Originally, these pasted and...

All, We have a workbook with 3 sheets, with about 1 million cells on each sheet containing values (about 11,000 rows, 90 columns). The workbook is coming out at 50MB, which is a bit of a pain for sharing. A lot of the cells have reasonably complex trigonometric calcs, such as...