range selection

Hello, I'm new to the forum. I've got a sheet where there sometimes exists shapes which cannot be targeted by the mouse (there are several different ones, they're not all the same shape). I want to be able to remove them anyway, however I want to also control which ones I remove since some...

Hello everyone, I am working on a VBA code which changes positive figures to negative figures and vice versa. The code works fine if i select more than 1 cells but if i select only one cell to change the figure from positive to negative or negative to positive then all other numbers get changed...

Hai Dudes, I would like to select the range of cells in one row which contains some merged cells in between. The macro has to be run for many files with different range of cells. For example File1 has to be select from C5:C10, file2 has to select from C5:C20. There are some cells merged in the...

Hey, so I will make this fast. I am looking for a way to select a range of cells, starting with A17, down column A, to where a bottom double line border is. There are no other bottom borders in the range. The range can vary, i.e. A17:A46; A17:A2345837, etc etc. All of the range's cells may...

Hello i have to create a vba code to send email of the first row then next row then so on i have created a vba code but i have few issues the values in COLUMN A SHOULD GO TO THE "TO" FILED OF THE OUT LOOK and B C D E F G H should go to the body of the OUTLOOK please help me out and i will post...

Hello I am struggling to select a variable range based on the second row and last row. All I want is to select the entire rows between the variable second row till the last row. And then I want to sort them. I am able to define the last row easy which is quiet straightforward. And I am also...

Dear all, as you will see below I remain not even a novice at VBA despite the length of membership. I have some VBA written by a third party where cell refs are used rather than range names. I appreciate at some point I need to probably try to spend some years completely re-writing to work...

My objective is to select cells on row for columns F thru X and have conditional formatting comparing to cell on same row in column z. I need to loop through row 3 thru 70. Sub FindLowestCost() Dim i As Integer For i = 3 To 70 Range("F3,H3,J3,L3,N3,P3,R3,T3,V3,X3").Select '****this line is...

I'm attempting to highlight an array plus an additional, empty (or partially empty) column to the right of the highlighted array. I'm using "Range(Selection, Selection.End(xlToRight)).Select" to highlight the data. <TBODY> A B C 1 Data Data No Data 2 Data Data No Data 3 No...

Hi All, I'm not good with VBA, but have made a macrothat will autosend an email from Excel via Outlook when a certain condition is met (i.e. cell x value = cell y value). The email body contains information from a range of cells using the "Select.Range()...." functionality. I would like the...