range

Hi everyone, Is there any possibilty to simply write value of range variable into cell? See my code Dim SpecifiedRange As Range Set SpecifiedRange = Application.InputBox("Označ myšou v exeli z 3D rozsah kopírovania pre 1 kartu", Type:=8) Dim Range1K As String Range1K =...

Hello everyone, I'm back here for help again so please bear with me. I have a vba code that is triggered when there is a change in a range of cells. It works well if the changes are done cells by cells but i get an error in the case if i were to copy and paste for multiple cells in one go. I...

Hi, I am sure this may be availabe in simple math but I need a formula for it. Say I have a range of numebrs where 1 is the lowest and 73 is the highest, with all other numebrs in the range. How to i streth this both ways so that 1 becomes 0% and 73 becomes 100%? Which means 37 may be in and...

Hi, I am trying to divide the result of one sumifs() statement by the result of another sumifs() statement, but the sum range and criteria ranges referenced in the second statement are not working.The ranges are valid but they are not highlighted in the sheet and the formula returns an error...

In VBA, I have a multi column range on one sheet (DocMgr!$Q$8:$V$27) where, on another sheet, I need to find the max value in the second column if the first columns meets a certain condition. The way I found to do this is to write an array formula to a cell and then get the resulting value like...

I have a spreadsheet that I am trying to populate by using an array formula. Right now, I have a formula that looks in a range and identifies if the word "Spouse" is within it. However, I would like to update the formula to search for "Spouse" & "Ex-Spouse" within the same range, but my current...

Hi there, I have a worksheet, that has data, but want to start the capture on line 9. I tried to use the below to find the last row for S9, but seems when running this, it only copies/pastes F9. I would like it to continue until the last row of S9:end. Note that S9 starts with values, then has...

Hi. I have a macro that looks at a cell for a name, references another sheet and gets the email that corresponds to the name, and sends an email. I hopped into VBA and thought I entered the correct data to expand my vLookup. The original expression is: Recipient =...

Hi all, I am very new and very inexperienced, I hope someone can help me. I have 2 questions see below first one: I want to find duplicate dates for my database, but not working. I want to show how many duplicates too. Private Sub Textbox3_afterupdate() Set rng = Range("E2:E3000") Dim ws As...

Hello, I'm trying to figure out how I can select a range based on a date within the current week. Example of selection… The order I'm trying to step through is the following: 1. Declare Friday as a variable to store the date using a formula: =TODAY()-WEEKDAY(TODAY(),16)+7 As of today...

Hi I am trying to save the data into the MainInventory but unable to do as I keep getting this error When my sheet is empty and insert the second row as my first row is headers row the data is inserts fine everything works fine but as i enter the third row this pops ups and my vba closes and...

I have a spreadsheet that have pay period dates, that run from V5 to AT5. We have the past pay months within 1 month grouped together and the future months within 1 month grouped together. For instance this month is August, so all the columns with dates in July, August, and September are not...

Is there a way to only copy certain columns from an auto filter? With the below example the active sheet has 8 columns of data G, L, P, R, S, T, W, AB (other columns have been hidden) When I copy the data, I don’t want to copy column W & AB so that only 6 columns of data will be moved to...

Hello! I've searched high and low across multiple forums for this specific answer, but I can't seem to find it based on cell value. I can find the VBA code for ALL worksheet names to be listed in the ListBox, but not specific ones based on cell value to be used as selections for printing...

Hi, trying another range, and for some reason it's not pulling all the details. Set WBrng = Range("A1", Range("J" & Rows.Count).End(xlUp)) WBrng.Copy it's only displaying A1-J1. I'd like the last row to be dynamic in the event it goes longer than 9 rows: sample data: Header Header...

hi! I have a sheet which contains content in cells A1:H3, row 4 & 5 is blank, and row 6 starts a new table A6:H9. I was trying to declare a range for A1:H last. In the event the top table 1 row, or 2, or 3, I wanted to have the range select the last row. doesnt appear to be working properly...

Can anyone please assist me on this request and here's the link for it: https://stackoverflow.com/q/76588334/13644020

Hi, I'm wanting to count the number of 'Yes' values in columns B and C, but only count the 'Yes' values after the last entry in column D for the associated location. In the attached example, for Kettering the count should result in 1, as there is only 1 'Yes' in columns B and C if we count...

I am using the following for a macro: Dim y As Long For y = 1 To Cells(Rows.Count, “AK”).End(xlUp).Row If Range(“AK:AM” & y).Value = “DRUG REQUIRES PRIOR AUTHORIZATION” And Range(“A” & y).Value = “” Then Range(“A” & y).Value = “PA REQD” End If Next y However, I keep getting an error...

Hi Mr Excel, How to get result in Column Q & S? Given number of range to check for Column Q in M , Column S in O The Range to check in Column G. Example : Cell O6 show 2 number of range , then check how many value < -0.6 in Column G and the result is 1 in Column S. Same goes to Column M for...