quick

Hi, Long shot - but I have a sheet with around 700 rows. In column A, there is paragraphs of text in each one. Inside these, there is various links ending in .jpg, .png etc - however I'm specifically looking to replace the .gif ones with the new .webp ones I have in column B. I have done a...

HI All, hoping for some quick help. Most probably a quick easy fix, but cant think what other way to work it. I am trying to use the below formula, but it isn't correct and I am not sure how to fix it. =IF(Original!P2=400 or 250,0),round(Data!Q2/Data!P2*100,2) Basically if the data in the...

Can anyone provide me with a quick way to remove every other row in a spreadsheet report?

Since I'm not that well versed in VBA, unlike most on this forum, I was hoping someone could answer a quick question regarding "Sub ComboBox1_Click()". I thought this was a mouse click event, but as I seem to be finding out, it is also a key click event. Is this correct? I'm wondering...

Is there a quick way to copy slicers to all sheets at once rather than sheet by sheet?RegardsStephen

Hello, I have been in and out of Excel (365 ProPlus) several times today. After exiting the last time and then starting it again I noticed the Quick Access Toolbar has reverted to the default toolbar. I had about 20 or so short cuts (both commands from the ribbon and from my macros) on the...

Hi, I have a file I'm working on roughly 5MB with about 12 sheets and a lot of formulas. I'm wanting to save a copy of the file often (values only) but want to do it as quick as possible. SaveCopyAs is pretty quick but it saves an exact copy. Where creating a copy of current workbook, removing...

I want to quickly put a range of cells containing text into an array called blockstrings. Why does the following not work?: blockstrings = Worksheets("VBAinputs").Range("a5:a" & blocknameslastrow) instead i have to use the following to make it work: Worksheets("VBAinputs").Range("a1").Select...

So I have a question (which I hope someone can give a quick answer). What I am trying to achieve is as follows: 1 2 2 3 3 3 4 4 4 4 So essentially have the number pattern/repeat based on the number itself and also increase. I need this to go all the way to at least number 36. Anyone has a...

I have a chart in a sheet that doesn't update when a macro I wrote runs. After if I click on the chart it updates. Any idea what I can do for quick fix.

One of the best things about the Quick Access Toolbar in Excel for Windows is that it automatically creates shortcuts for the items included in your Quick Access Toolbar. For example, pressing Alt+1 triggers the first item in your Quick Access Toolbar, pressing Alt+2 triggers the second item...

Hi In my workbook, I have disabled Formula Bar and Headings (from View). This file is password protected. Password. I have 'auto-hide' ribbon too. However, by doing this, the 'undo' and 'redo' buttons that sits on the top in the "Quick Access Toolbar" disappears. Yes, we can always take our...

Quick question because my mind is blanking- I have a macro that I'd like to have run if the value of Cell "A1" does not equal the value of Cell "B1". I'd like to insert the piece of code in the front part of the macro. If A1 does equal B1, a msgbox opens that says "hello". p.s. Sheet is named...

I am a big fan of the Quick Access Tool bar which I have customized to give easy access to my most commonly used functions. I have them grouped logically. For some reason the icons don't stay put. The icon in one location keeps moving elsewhere on the Tool Bar. Occasionally, another icon...

Hi, This formula works when it is in the worksheet but when I try to transfer it to VBA I am missing something with the quotation marks etc. Any assistance appreciated. I'm sure it is a quick fix for the right person. Thanks Ryan "=IF(RC22="""","""",IF(HLOOKUP(RC22,INDIRECT("'CATEGORY...

IF(AND(A2="Category1",B2>-1,B2<2),"Yes","No") I just used F9 and think I have too many arguments in the AND(xxx). How can I say B2 should be 0 or 1? e.g. (B2>-1<2) or (>-1B2>2) Thanks for your help.

This may be simple, but can't figure out how to write this up yet...any help is appreciated if column B matches column A exactly, then check if column D is contained somewhere in column E. If so, return Yes

Hi all, What I am looking for is a quick VBA solution for this issue. When the sheet "opens" I would like it to search row 3 in the spreadsheet and match the dates in those cells to the current date and move the cursor there. I can't for the life of me remember and when a friend wakes you...

Hello - does anyone know if it is possible to enable/disable add-ins from a shortcut button on the quick access toolbar? Thanks, Mr R

I have several UserForms with many TextBoxes. To quickly ClearContents I've tried this which produces Object required error. Any suggestions? For i = 1 To TextBox.Count TextBox(i).ClearContents Next I