selecting cells

Hello, I am extremely new to VBA. I am trying to do something very simple and I am running into this error. In my Excel Workbook, there are several sheets. The ones of interest are named "CAR Daily Report Macro" and "CAR Daily Report." I am setting up a macro to copy and paste data from another...

Hi Guys! Needing your help with this. What I would want to do is to: 1. Hide the rows that has the value of "FALSE" as a result of an IF and VLOOKUP formula. 2. Select the cells and set the print area. 3. Print as PDF - I am already good with this :D Thank you.

I would like to select all cells in the dataset A2:F156 where the color index is 19 (light orange) or 40 (dark orange). I have uploaded a picture of my dataset below. I have compiled the following code: Sub SelectByColor Dim cell as range, rng as range Set rng = range("A2:F841") For each...

I have a dataset for wells and 5 treatment plants (TP1, TP2, TP3, TP4, and TP5), which extends from A1 to F841. The flow path for each well is such that the well flows to TP1, then TP2, and so on. However, sometimes the flow path does not extend all the way to TP5. I have manually entered "None"...

Hello all, I'm trying to select a range on my sheet "Master Availability" based on my selection in the sheet "Employees" When my code runs and the active cell in Employees is C6, then I want to select the cells E89:R89 (offset by 83 rows) so that I can call an additional sub to run on those...

For example Cell A1 contains - For you to understand Cell A2 contain -- I am Cell A3 contains = doing Cell A4 contain - this Thank you In the above example, Cell A3 has only one word and the rest have more than one word. I want to select all the cells which have only one word. Thank you

I want to see the details of a selected cell in pivot table in a specific sheet not automated sheet , is that possible? selection.showdetails=true sheets("details")

I've searched around for this but can't find a suitable answer. Is there a way to return (in an if statement) a truly blank value? I have a long list that is generated by an if statement and I want to be able to CTRL-SHIFT-DOWN-ARROW select just the cells with values. When the if statement...

Hi. I know there have been similar posts about this, so apologies, but they all seem too specific to people's own reports etc... Essentially I am copying data from multiple sheets of data after a filter is applied and pasting them into my main spreadsheet. I am struggling to work out how to...

Hi all, I have a column that has 10000 words. I also have four columns ( numbers) related to each other ( one line is specific for one of two words ) and each have 10000 values. So it is like this as a small example: GO 1 3 GO 2. 7 Wait 3 4 GO 3.5. 6 Wait 4.3 0 GO 3. 7 Wait 2. 6 What I...

:confused: Something has changed in accessing one or more cells. To start off, the work sheet works on one computer as usual. When opened on a different computer the normal "left click a cell" doesn't bring up the usual black select border, nor can you left click the column letter or row number...

Hi, I have no idea what has occured here, but have been trolling forum posts for a good few hours and am still unable to find a working solution.... My problem is this: I have an excel workbook which is heavily reliant on Macros to move data around within the workbook and also clear data...

I have a weird situation I don't know how to correct. When I select a single cell, Excel will also select 2 (or 3) cells together, usually the ones under the cell I want. This only happens on certain worksheets of my workbook. How do I stop that from happening?