1. K

    Excel VBA - trying to reference values of a range using cells

    I am trying to set the values of cells in a range in the current worksheet to be the values of an equivalent range from another worksheet using .range(cells... since the range size is variable This works perfectly: Range(Cells(2, "A"), Cells(ListSize, "A")).Value = Worksheets("Staff...
  2. K

    VBA : Copy forn another worksheet only the new information.

    Hi, I am new into de forum and kind of new into VBA. I have written this code(with some support of youtube videos etc) to copy a specific Sheet from one worksheet to another. Sub CopytoWorkbook() Dim x As Workbook, y As Workbook Dim ws1 As Worksheet, ws2 As Worksheet Dim LastRow As Long Dim...
  3. Saher Naji

    Change color of cell to Yellow once I copy it

    Hello, I'm trying to use this code to change the background color of a cell to yellow when I press Ctrl+C and has it stay yellow. This should be applied to every cell I copy. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Application.CutCopyMode = xlCopy Then...
  4. F

    Highlight active row Except cells that are currently highlighted

    Hey Team, I have this code that highlights the entire row of the active cell. But I don't want it to mess with the cells I already have highlighted in that row. Is there a way to modify this to only highlight cells that are not currently highlighted?? This way my highlighted cells are not...
  5. R


    MC allows for conveniently selecting multiple discontinuous cells as a single parameter within the syntax of formulas MC stands for "multiple cells". Many functions allow for selecting one cell or a continuous range of cells, and attempting to select multiple discontinuous cells through commas...
  6. D

    Referencing Cells from a Separate Work Book, but NOT Cell Position

    Hi Everyone! What I am trying to do is link start and end dates from one work book into another, but not the exact cell position where the date currently is. I can do the first part easily enough by putting "=" in the cell of my current work book, and then selecting the date cell from my...
  7. R

    Replacing cell contents with the lookup value of that cell

    I'm at a point where i'm bringing in two columns with values (city and county) and i've got a lookup sheet where the value of the state - Say Michigan (or MI) is 45 for example and the county is 13. I'm inputting MI in to the cell but would like for it to somehow reflect 45. I'm wondering if i...
  8. F

    Selecting pictures within highlighted cells

    Hi, I’m trying to delete a picture within a certain number of highlighted cells. I’m trying to do this in VBA and every suggested code I’ve tried doesn’t work or requires specific cells to be selected however I’m highlighting the cells via ActiveCell.Offset codes. The sort of thing I’m after...
  9. Jyggalag

    Remove weird borders from Excel cell?

    Hi all, I currently have an excel worksheet with this information: Apologize for blurring out all the information. However, there are a bunch of weird borders around some of my cells that popped up when I started copy pasting data way back. Now, no matter what I do by filtering with "no...
  10. T

    Go To Cells That Dont Match From Table

    Hi Everyone, I was trying to make a VBA code that would compare a list on a page "Locations", and go through all of the other sheets comparing a column in these sheets to see if there is a match or not. If there was no match, ignoring blanks, the VBA code would go to the cells where the match...
  11. E

    Box parts of text within cell

    I would like to box parts of text within a cell. I know it is possible to format the font of partial cell contents but is it possible to box it. I have attached a picture of what i would like but in just one cell. using Office 365
  12. V

    Trying to use selection in a listbox to resize a selection of data

    I am trying to use a listbox selection to lift only a small segment of the data out of the source of a listbox. I am trying to use the cells argument to pint point the starting spot and then resizing the selection to pull data into another part of the workbook. Unfortunately the resize argument...
  13. H

    Macro to move cells from one column to another column based on value from cell (Calendar)

    Hi, I have just got a hang of macro but need some help with coding in VBA! I have a calendar with a lot of different activities placed in different cells. Let's pretend that my activities are A,B,C. The cells in the calendar (workbook A) will be externally referenced with data (dates) from...
  14. S

    =IF statement assistance

    Hi, I am hoping you could assist me with a formula I need. K2 has a drop down list with the following options; 12 month nomination or 2 year review. K36 needs to be able to calculated based on the option selected above. e.g if 12 month nomination is selected then K36 needs to divide K35 by...
  15. L

    Power query % help

    Good morning, I am writing to you because I am completely blocked ! I have an array with formulas in Power Query ! The principle is simple : Get the difference between "cash buy (achat comptant)" and "cash sell(vente comptant)" values ! There is a file in history and a graph. I would like to...
  16. J

    Macro Help!

    Hi I'm trying to create a Macro so from my worksheet by pressing a button it will export it as a PDF, but then save it based on 3 cell Values, C4, C6 & C8. C4 is a name C6 is a name C8 is a date I'm wanting it to save to a specific file location to: C:\Users\Vector\Google Drive\H_O...
  17. P

    How to fill Filtered Cells with data??

    Hi everyone, I am trying to use to populate the "AD" column fields (filtered by rows that contain data) with the word "SENT". I can't seem to manage to fill the correct cells due to filtering. "SENT" needs to be populated in the AD column in the cell where there is filtered data also needs to...
  18. Y

    How to delete data from Non colored/Highlights Cell from excel?

    Hi There I am working on big excel , where i have highlighted few cell where which need to be uploaded and rest of data which in non Highlighted should be deleted. This Data has 300 Column and 10000 Rows Any help how to delete the data from non highlighted cells.
  19. D

    Help me understand my VBA code please (easy) - thanks!

    Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...
  20. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back