selection

  1. D

    Dependent dropdowns

    Hi all, I've created a spreadsheet with multiple dropdowns, and while it's been working perfectly, I have added a new item to dropdown A, and for some reason can't figure out why it won't link dropdown b to provide me with the coinciding info. No tables present, but dropdown B info is located...
  2. G

    Excel VBA - Count number of rows and columns in range

    I want to get the number of rows and columns in my "selection" range, but for some reason Columns.Count returns 1 when I have multiple columns selected. Anyone knows why? I am using excel 2013 32 bit. Sub test() Dim sourceSht As Worksheet Dim targetSht As Worksheet Dim Table As ListObject Dim...
  3. G

    Count number of rows and columns in range

    I want to get the number of rows and columns in my "selection" range, but for some reason Columns.Count returns 1 when I have multiple columns selected. Anyone knows why? I am using excel 2013 32 bit. Sub test() Dim sourceSht As Worksheet Dim targetSht As Worksheet Dim Table As ListObject...
  4. D

    Fill blanks macro

    Hello, I need to fill all blank cells , or = 0 in my selection with "1" Thank you
  5. T

    Adding second criteria (if not blank) to this formula

    =IFERROR(IF($L$28="",OFFSET('Master Data'!B2, ($F$2-1),0),INDEX(tbl_data,SMALL(IF(tbl_data=$L$28,ROW(tbl_data)-1),$F2),MATCH(G$1,tbl_data[#Headers],0))),"") L28 is location selection L29 is product selection F1-O1 are the header cells for the scrollable area. F Column contains the "record #"...
  6. T

    Formula for populating data from another sheet into a scrollable table

    Hey there, I currently have a sheet build (let's call it a dashboard), where there is an an area that pre-populates data from a master table and is scrollable using a form control bar. In the designated scrollable area, this is the current array formula: =IFERROR(IF($L$28="",OFFSET('Master...
  7. G

    Setting a SetRange to the highlighted selection

    Hi Team, Forgive me for some of my lack of knowledge of syntax and proper definitions on even the beginner details of VBA, but I have a certain scenario I need help with. Basically I have four seperate ranges on one sheet (Stacked on top of each other with one row between each). These ranges...
  8. D

    Random selection from range where the selection is constrained of whether or not another cell on the same row ISTEXT

    Dear folks, hope that all is well. I have a frustrating problem with a random selection from a range given that another cell on the same row is text/not blank. Below table might help to explain the circumstances. What I would like to do is to select a row completely random, constrained on the...
  9. D

    VBA If Entire Row selected in Selection Change Event

    Hi, Is it possible to check if the Entire Row of Row 1 is Selected in the Selection Change Event? Can someone help please
  10. DataBlake

    Get the last column of a selection

    I want to store lastCol as a variable equal to the last column in the current selection Sub selectionEDIT() Dim sSelect As Range Dim lastCol As Long Dim lastRow As Long Set sSelect = Selection lastCol = sSelect.SpecialCells(xlCellTypeLastCell).Column lastRow =...
  11. L

    VBA to use activesheet selection in Transpose

    Hi I am using the built-in function Transpose to convert an array to a string and would like to use the current selection ie change this Comments = Join(Evaluate("TRANSPOSE('Base'!A1:A10 )"), vbNewLine) to Comments = Join(Evaluate("TRANSPOSE(Selection )"), vbNewLine) The latter gives a...
  12. E

    Autofit rows based on Slicer selection

    Hello Excel Gurus! I am trying to create an interactive dashboard using Slicers, Pivot tables/charts and Index/Vlookup functions. There is a section where I am using INDEX to lookup text based on a Slicer selection (which I have linked in my INDEX formula). The text varies in length based on...
  13. muhammad susanto

    VBA : Resize 2 Pictures in Specific Range (G13 & D13) Wtih Simultaneously

    hi all.. i found macro code to resize picture in Excel... here this code : <tbody> Public Sub FitPic() On Error GoTo NOT_SHAPE Dim PicWtoHRatio As Single Dim CellWtoHRatio As Single With Selection PicWtoHRatio = .Width / .Height End With With Selection.TopLeftCell...
  14. D

    Format Painter: Clear All in Clipboard not working

    In the Home tab, when I click "Format Painter", it opens the Clipboard. Sometimes there is an item there called (preview not available). I will hit Clear All but it doesn't get cleared. Also, when I Copy my selection in order to add to the Clipboard, nothing happens. Anyone know what is the issue?
  15. most

    Retrive adress from selection

    Can anybody explain why this happens? With the third case I expect the result to be $A$12 $B$13 not $A$12 $A$13 Sub Sel() Debug.Print "C:" & Selection.Count Debug.Print Selection(1).Address Debug.Print Selection(2).Address Debug.Print "---" End Sub The grey areas are the cells...
  16. B

    If a cell contains 'x' then select row to left and clear formatting through loop

    Hi, This is my first ever post - scary stuff! I've been hard at learning VBA for both excel and word for the past year to help me create massive efficiencies in my day to day duties at work. Currently, I'm working on an excel sheet that is a snapshot of projects that are currently being run...
  17. M

    Sorting Listbox items

    I have two listboxes Items for Selection (this is a multi select) Items Selected When all the required items are selected the user will click a button to send them to the Items Selected Listbox. When they appear in the Selected listbox I need them to be in alphabetical order and as I am...
  18. R

    VBA: Using 2 variables with Match

    ws2.Range("D3").Value = Application.WorksheetFunction.Match(variable_i, ws2.Range("A:A"), 0) ws1 = worksheet 1 ws2 = worksheet 2 On ws1 I have 2 columns of drop down boxes (data validation list) the selection from the first column of drop down boxes is assigned to the variable "variable_i"...
  19. O

    Sort selected range by font color

    I am trying to get this code I found online to work for my need and cant figure out how to combine it. The first bit Sort_Selection works great to sort by value, but I need to sort by font color of selected range. This code is really terrific in that its not specific to a sheet name and such and...
  20. N

    Macro to Paste Values over filtered selection

    Hi, I've developed a macro that pastes values for a highlighted selection even if that selection is filtered. Two questions - have I done this correctly? Is there a way to build in an undo function? Obviously since it's a macro you can't just hit the undo button. Sub PasteRight()...

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
Back
Top