selection

Hi All Another problem. Im seeking a function or macro to move all the data from a selected series of rows, into the top most row of the selected area. Example below. There are 12 rows of Romboutsia (84 to 95), and all rows will (/should) have 1 data point. Im looking to move all the data from...

Hi! I have a macro that fetches a file from an email in Outlook every day, and then runs a number of other vba codes on it. The macro runs great, but only gets the file from "today" and if there is multiple emails it only collects the oldest one. As a workaround, I sometimes have to email...

Hello! I'm trying to highlight the active row in a table. I have multiple table in 1 sheet and I already formatted the sheet to highlight the row when selected. However, when selecting the row in a table, it also highlight the same row in all the tables. is there a way to only highlight the row...

Hi Please some one help me to find the solution for the below question? I have 2 sheets called Buttons and Database as shown in the below image. Upon button selection I would like to show only selected Name/Skills in Database sheet. eg: If "Dinesh" button selected show only Dinesh rows in...

I am looking for a Formula that will count a price based on the selection of a few Radio Buttons. So for instance =SUMIF(B1+(Radio selection 1=1, then add B2, if radio selection 2=1, add B3...etc I know this isn't the correct use of SUMIF but this is the essence of what I am trying to achieve...

Hello, I have an exported, filtered list of results (not a table) where one out of two rows (the second one) describes the first one. Now I'd like to select these pairs of rows dynamically in order to format their borders, among other things. I'd like, for instance, to give the impression of...

Hi all, Worksheet_SelectionChange event doesn't fire if I change the selection from a cell to an image. Does it only fire if a cell is selected (it seems to be the case, but I thought I'd check)? Option Explicit Private Sub Worksheet_Activate() Application.EnableEvents = True End Sub...

Hi all, I am looking for a way to clear the content of all the cells outside my area of interest (designated by the orange oval): Close up, it looks like this: I would like to clear the content of ALL the cells that are not encircled, and including those coloured in orange. How can this be...

A while back, I used bits and pieces of code to cobble together a macro that selected, not highlighted, the current column and row of the active cell as I needed any range customizations to be unaffected. It involved, of course, the Worksheet_Selection_Change event. But it also involved a Class...

Hello- Trying to create a formula that randomly selects a tracking ID for each associate. In addition, make an alternate selection, but it can't be a duplicate of first random selection. Was thinking a VLOOKUP & RANDBETWEEN combo, but stumped. Not sure if I have to go through VBA route? Any...

Hello, I'm trying to write a macro that copies all selected cells and paste it somewhere els. My problem is with the selection part. I'm using: Dim CopyRng as range Set CopyRng = selection The problem: If I select multiple rows with the CTRL hold in, it only copies the first rows. Example...

Hello! I'm trying to write a simple macro that will delete few rows, than sort by values from one of columns and than delete few rows below some value. I am using the strings of the code just strictly from "record macro" function. It does have codes like rows("1:6").Select or...

Good morning all, I have a macro that runs when a user double-clicks a cell. Among other things, this macro opens a userform. Is there a way to make the user form open to the right of the double-clicked cell every time? The location of this cell moves down the sheet as the user activates the...

I am having a similar struggle as the OP in this thread, except in mine I am trying to go to to the left, minus 1 (or would it be plus 1?). I basically just want to start at FM8 and select all the way left, then move the selection to the right one column. I recorded the macro to try and get...

Hello, I have a spreadsheet with column I where there is a lot of data. I have the 1000 which is the sum of the 2x500 (bold) The 2x500 are the sum of the data (first one is 200 =300 and second one is sum of 5x100) I would need a VBA that would populate the formulas taking in consideration the...

I have a workbook with different worksheets. As these have different orientations you can't simply select and print them, as the page orientation is the same on all of them as on the first page. Now I would like to create a macro with which I can print the selected pages (which are not always...

I would like to add a pop-up Message box that happens in this code after the DoCmd.RunCommand acCmdSaveRecord. "Do you want to return to the TSL?" If Yes then then DoCmd.OpenForm "frm_NIS_TSL", acNormal, "", "", , acNormal If No then the DoCmd.GoToRecord , "", acNewRec command Any help is...

I have a range of cells with values inside. The values have pattern such as '123-abc'. Now I need to change the value of selection to just 123. I currently use left function to loop over the selection. But it's very slow because I have 1000 cells.

Hello Friends, Is there a way to move the selection to the second column of that same row. Like if the selection (target cell) is lets say column H32 then I would want the code to make the selection to B32 or if the selection (target cell) in on A15 then i would want the code to make the...

Hello all, after hours spent trying to find a solution online, which was unsuccessful, I decided to post a new thread and see if anyone could help me out. I have multiple pivot tables connected to timeline slicer where user can select time period to view data set. I found online how to get...