1. T

    VBA Select the workbook the macro is running from?

    I would like to select less specifically by name but rather by saying, the workbook this macro is running from, select that one.
  2. P

    VBA to select filtered values and erase data

    Hi, I need a small bit of code to select few columns. I use activecell.Offset function to select a cell. But is there any such formula to select a column? My querry is I have data from Column A to Z. Now I do a filter and pick a value from column A. Now I need to select column A to D filtered...
  3. L

    How do I select a row with vba?

    Hi all, I'm sitting in front of a deadline project and I seem to be forgetting the basics.. my own name will be the next one.. I'm getting compile errors and I can't figure out the correct syntax. Sub try_this() Sheet4.Activate Dim headerrowin As Long headerrowin =...
  4. W

    specify gap size using Randbetween function

    How can RANDBETWEEN(1,850) be modified to select numbers <+8 or >-8 of the previous selection? Thanks, White Top
  5. N

    VBA - Copying cells in a range that match criteria

    Hello everybody, I am trying to write VBA code to copy cells from a range of non-contiguous columns (A:K, O:Q) to a new sheet if certain criteria is met (a cell in columns O:Q is populated and cells in column F do not contain a key word). I am able to specify the criteria but the code I've...
  6. B

    Help with a macro please

    Hi Everyone, The macro below is an HTML copy from a folder(file:///C:/Users/HOME/Dropbox/DAILY_SALES_REPORTS/DAY_END.HTML) and pasted to a worksheet(IMPORT_HTML). Works like a charm until the DAY_END.HTML file is overwritten which we do daily. The way it was recorded is to open folder...
  7. J

    Select distinct but return all fields

    I want to select a single distinct example based on one field in a table. Something like: Select table.* From (Select distinct table.[country] from table) Where( . . . .) Is this possible in access sql?
  8. G

    Macro to select text and go to next line

    Hi Im having a weird problem, I have copied around 2500 lines of dates into my spreadsheet, and some were in date format others were in general format. I have changed the format of the column to date, but the ones that were previously just text are staying formatted as text. I've found if I...
  9. C


    I am trying to Rank in Access. Here is the Data. <tbody> SNGL_SYS_ITM_ID END_EFCTV_DT 000000031 000000031 12-Nov-18 000000031 15-Nov-18 000000046 000000050 000000051 000000052 000000052 16-Mar-17 000000055 000000070 </tbody><colgroup><col><col></colgroup> Here is...
  10. L

    random numbers from 4 different sequences into one

    I have 4 different check # sequences. I do a % of the total number of Checks based on the total. I then used the # of items to select, of each of the sequences to = my total sample size of 25. My question is, how can I get the random # to select and then put them all together to give me my 25...
  11. S

    Select Section between blank rows

    Hey Team, I have a worksheet with data in columns A thu E that is broken into sections separated by blank rows and a unique "Title" in column A starting each section. I need to select the col A range of a section so that I can format each column differently. CurrentRegion doesn't do it because I...
  12. L

    VBA to filter multiple sheets based on a cell on another sheet

    I've been doing some digging and have found a few answers but nothing that does specifically what I'm trying to do. I have an excel file with over 10 sheets and four of these sheets I need to apply a filter to based on a selection made on another sheet. I'm currently using the code below, but...
  13. P

    Select last used cell And it's Offset

    I would like to use "Range("G" & Rows.Count).End(xlUp)" to determine the last used cell in Range("G"), and select it AND its "Offset(1,0)". I am running into issues when pairing it with the Autofill code from Macro Recorder. See below: What I need to do (This is only an example, and does not...
  14. U

    Compile error: Statements and labels invalid between Select Case and first Case

    My VBA script errors when I try to insert data from Sheet1 into Sheet2. I get the following error: "Compile error: Statements and labels invalid between Select Case and first Case". I removed the second "select Case" all works okay, listed below, VBA script. Wondering what else should be...
  15. S

    popup to select row, then concatenate

    Hello, I have a spreadsheet that has multiple columns of data. I need a macro that will prompt the user to select a row, then concatenate the info into another cell. The point of this is so the data can be copied, and pasted into a label maker. This label printer only prints from its...
  16. R

    Select multiple items in Slicer

    Hi, I am trying to select multiple items in a given slicer, i recorded a macro to check how it happens and the result is below Sub Macro1() ' ' Macro1 Macro ' ActiveWorkbook.SlicerCaches("Slicer_costcentername1").VisibleSlicerItemsList = _ Array( _...
  17. B

    VBA Case Else working / Case not working

    Dim c As Range Dim i As Long For Each c In Range("C1:Z1") For i = 2 to 26 Select case i Case 7, 12, 17, 22 c.Value = "=" & c.Offset(0, -1).Address & "+3" Case Else c.Value = "=" & c.Offset(0, -1).Address & "+1" End Select Next Next The above just...
  18. M

    Select a Shape that Intersects (touches) a Cell (range) using VBA

    Using VBA code, I will be placing a shape somewhere within a large cell range. But FIRST I NEED TO REMOVE THE SHAPE that may already be there. I know the shape will intersect or touch a certain cell (G13). So, I need the code to simply select this shape and then, I can move it to another...
  19. V

    Filter by Select All

    Hello All I hope you can help on this please I have a drop down list in cell "P2" which allows me to select a value that then triggers a filter with the code shown below. Question 1 - How can I make this range Dynamic as the rows change daily. Question 2 - It is possible to put a value in...
  20. S

    Select Range in non-selected worksheet - Possible?

    I understand this will seem like a strange query, I guess it may just be a little OCD kicking in, I get annoyed when I've ran some code on a worksheet and various cells are highlighted when I select the sheet for viewing. Is it possible to deselect all cells in a worksheet, or select...

Some videos you may like

This Week's Hot Topics