entire

Hello, I am using the row/index function to insert values from another sheet when certain criteria are met. Unfortunately, I’ve noticed that the formula seems to only shift cells down in that column whether then inserting an entire row for the value. Is it possible to adjust the formula below...

Hello. I'm struggling with a formula using IF, LEN and VLOOKUP. I need to manipulate what VLOOKUP returns. If it returns a 10 character string I need to only pull through the first 5 characters, otherwise return the entire string. =IF(LEN(VLOOKUP(A2,'[Powys...

Hello, I have a couple of columns that seem to have UNCHAR (62) in them. The ? symbol. I am trying to remove them. I tried to find and replace but it removed the entire cell. Here is an example of what I am trying to fix: Arrow Rivet, ?.312 Hole, ?.219 Panel Thk

Hi, I am trying to conditionally format an entire row if a cell within that row has a particular entry. So in Column "AQ" there is sometimes an entry that has the first 2 characters as "S-" and after(no space) there will be a string of numbers between 4 and 6 digits long. I am hoping for help...

Wondering if there's a way with VBA to do the following. I need to get the data in C:2 and D:2 into E:1 and F:1, the data from C:3 and D:3 into G:1 and H:1. I need to repeat for the entire sheet. Can this be done with VBA? https://drive.google.com/open?id=189R34HQhkflk6wh-mlxhj6aJtblTX5Ed

I would like to have a certain range visible or hidden. Similar to entire columns/rows, but only the range. Let's say B2:F10 Is this possible? Thank you,

I have a protected worksheet with locked cells. Will need to unprotect and worksheet when perform delete entirerow action. Is there any way to check if user selects entire row, right-click and selects delete?

Hi, I'm trying to figure out a way to highlight an entire row green if the value in column AY=1020. Any idea how to use conditional formatting to do this? Or another easier way? Thanks!

Hi There, I am having an issue with some code I have created. What I would like to achieve is on my worksheet "Drawings" if the value in Column B is the same as Column F then the entire row will be deleted automatically. Here is the code I currently have: Dim rng As Range, DelRng As Range...

I am trying to group by rows. I did it before, and it worked. Now its not... I have nothing hidden, nothing filtered... I select four entire rows, click Group, check Rows...nothing happens What am I missing???

HI I need some help please, this is getting a bit much for me and its wasting time I HAve WOrkbook with 1 sheet ,,,,, Column A & Column B jack jack@test.co.za john dil dil@again.com peter...

Evening, how do I stop the below code applying to the entire sheet, i wish for it to only take affect on a set range, in this instance g2:g35 Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Task1: Show your active cell contents in cell E2 actval = ActiveCell.Value...

Hi all, I literally started learning VBA 3 days ago, using excel-pratique's VBA course but as I'm trying to be thorough I started to make a "dictionary" and I'm writing up the different selections that are possible. Could someone send me a working code for: Select entire Row AND entire...

How do I write an if statement that says if cell d10 doesn't match cell d9, then underline the entire row, then go to the next cell until there is nothing in a cell.

Hello, I am trying to have an entire row get deleted if the user double clicks a cell anywhere in column B. Column B is a Description column, so if the user double clicks that particular description it will delete the entire row and shift everything below it up so there are no blank rows. Here...

Hi I've got a dashboard with doughnut charts - lots of 'em and I need to be able to CF them based on the category NOT values. I am completely stuck. I have followed this: https://peltiertech.com/vba-conditional-formatting-of-charts-by-category-label/ and filled the cells with the colours I...

Hello, I am looking to lock and protect the whole active sheet except for the whole column with a specific header "Desk", which is Column 3. <tbody> Date Desktop Desk </tbody> In my code, the unlock applies to Column 2 instead of Column 3 as that is the first found match to the...

Hello and thank to anyone that could help with this one. What I would like to do is to make macro that will copy entire rows based on criteria from 3 different sheets into 1. At first I would like to copy First row from sheet Audi Q7 with header and then if in any of the last 4 columns (sheet...

Hello, I have this code however, I would like to make it run across the entire workbook: Sub RemoveLeadingTrailingSpaces() Dim r As Range For Each r In ActiveSheet.UsedRange v = r.Value If v <> "" Then If Not r.HasFormula Then r.Value = Trim(v) End If End...

How can I delete an entire row when there is a 0 value is a certain cell, say A1. Thanks for your help