rangec

I've created a button that incorporates a bunch of functions. Everything is working, but the process started taking an extremely long time after I added the function below. What I'm do with this function is deleting all of the rows that have formulas in them that end up equaling a blank cell...

I have a datasheet with a long list of text from row 2 and below. What I need to do is remove duplicates (clear, not delete), but not on full row, only on range B:D. The duplicates in range B:D should be cleared if their is other rows with the exact same values in the columns A, C, D and Q...

What would be the equivalent of Range("C" & ActiveCell.Row) for columns? Thanks Tom

For Count = Range("a" & Rows.Count).End(xlUp).Row To 1 Step -1 If Range("a" & Count) = "STIM" And Range("b" & Count) = "U$" And Range("c" & Count) = "053" Then Range("a" & Count).Value = "STIH" And Range("b" & Count).Value = "U$" And Range("c" & Count).Value = "981" Next think it said...

Hi Please could somebody help with an issue I am currently experiencing? I have the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim thisrow As Long If Target.Column = 3 Then thisrow = Target.Row Range("B" & thisrow) = Range("B" & thisrow)...

Hi, Please assist, I am trying to create the header and detail lines for an xml file from an excel Spreadsheet. Thanking you in advance for your assistance Column C is the customer code and part of the header information ( one header line) Column D is the stock code and part of the detail...

I would like a range that includes the number of rows +1 a cell value states. I've tried various versions of the code below. 'Range("C2", Range("C" & Range("MonitorTotal")+1).Value).Copy As you can see I want the range from C2 to C and the value from the named cell "MonitorTotal" +1. Thanks...

I'm trying to use a formula array to do some calculations.. this works.. Range("C" & LastRow + 4).Select Selection.FormulaArray = _ "=PERCENTILE(IF(L2:L" & LastRow & "=""15"",AC2:AC" & LastRow & "),0.4)" but when I try to replace the 15 with a variable (year) it just...

Hi guys, I have the below code to copy down cells up to the level of adjacent column. I have a couple of questions;, If I run the macro multiple times I get excess data cells at the bottom. Do I need to add an if statement to stop the copying of cells if it is already level with column to the...

Hello ! =) I have 2 sheets: “Sheet1” and “ALERT”. On ALERT, I have 2 column “A” and “B”. “A” contains dates and “B” contains variables (CCC, DDD…). On Sheet1 I have a table with 2 entries : From B4 to B12, I have all the unique variables from “B” in ALERT From C3 to AF3, I have all the unique...