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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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.

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...

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...