select a cell

Hello everyone! I'm hoping there's an easy way to select individual cells besides ctrl + click. Basically, I need to select individual cells with the TRUE value to insert a row in between them. Other than manually selecting the relevant cells, the closest I've gotten is using ctrl + F to find...

I'm having an issue making excel select the last cell in a particular column of a table. Here is the part that is causing trouble: For Each lo In wksNew3.ListObjects Set rngAuditNoColumn = lo.ListColumns(6).DataBodyRange 'the next 2 lines...

Hello there Excel experts ! I have the following request: I want the user to choose the value that he wants thought a drop down list and then the code (on the same sheet) will find the value and autoscroll and select it ! I have a drop down list that is being populated from a different sheet...

Help please! After browsing this thread and and others I have achieved to use this code to copy and past data dependent on a specific value in a column. I have 2 issues.. 1. After the row is found I would like to copy certain cells of that row such as A C and F 2. I would like to then paste to...

Hi Folks I have been pulling my hair out with this, i have found pieces of code around the place but this is just not working for me. to give you an idea, the code selects all of the data in x cells, copies the data, opens a workbook (master data sheet), finds the first blank cell in column A...

Hi All, I need to adjust this bit of code (shown below) to select columns G, AO, and AR not just for the title column (row 7) and a single selected cell's row, but for multiple selected rows. With ActiveCell Union(Cells(.Row, "G"), Cells(.Row, "AO"), Cells(.Row, "AR"), Cells(7, "G"), Cells(7...

Hi, I am quite new to VBA and have spent the better portion of the day reading forums so I thought I would just ask because I am stumped. I would like to have a macro that searches for a value in a specific cell in a column on another sheet. I simply want to select the first match in the...

I am having issues selecting the cell "above" in formulas. Example, I want to insert a formula into cell B10, which includes a value from cell B9. So, I select cell B10, click = , and then try to click on cell B9 to insert the value, but it will not allow me the select B9. I can click on any...

Hi Hope you can help me - I'm tearing my hair out here. I have this (Possibly uneloquent) code: Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False ActiveSheet.Unprotect If Target.Cells.Count > 1 Then Exit...

I have a workbook with a bunch of formulas and linked workbooks. While I check the various formulas, I use the quick keys crtl + [ to see where the formula is referencing. The problem I'm having is it will switch to another sheet or workbook and I have to find the original cell I was looking...

Hi. I have Table1 in which I want to be able to select a row, and copy the row into a Table2 within another sheet. In one column of the row, I have an arrow image. I've attached a simple macro to the image so that when clicked, the next few columns of the row are copied and inserted into the top...