selection

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

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

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

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

=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 #"...

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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