last column

I have a range of formulas (E12:O21) The Header Row is (E11-O11) - Total Row is (E21:O21). I want to use VBA to search that range of formulas and find the cells with values to return the "actual" used range within that range. I will use this new range to create a chart eliminating blank chart...

Hello everyone! This is my very first post on mrexcel.com but I've been a site regular for many months now. You guys rock! I always find a thread of someone having the same doubt as myself, but I now have a somewhat specific query: I have a data sheet that is updated monthly where monthly...

Hello, i have to find the last column with data(Column:AE in this case) in a Pivot Table excluding grand total column and row. I have tried different ways but all of it gave the column of the last cell( Column:AM) in Pivot Table. I have attached an image of the situation. Kindly help, Thank...

Dear All, I am working on an excel sheet which has 14 to 15 columns ofdata and I would like to copy some of the columns (according to the headername) and paste it to the next sheet. Sample below: <tbody> Reviewed by PACE Client Name Sub Engaging Parties DUNS Number GFIS Client ID ABCD...

Hi, I am looking for a code that will help with what I want to achieve. I have a table where I have to split a column using text-to-columns. The number of columns created after will vary time to time. What I now want to do is copy the rows to a certain column and then for each of the columns...

Long story short, my company creates a headache when you make anything with VBA, and I know this is SUPER easy to do in VBA, but as mentioned before I need to do this without VBA. I find the last row by doing: B1: =LOOKUP(2,1/(C:C<>""),ROW(C:C)) I find the last column by doing: B11...

Hi Guys Is it possible to select the range in column B from the last row with data in to the last column with data in row 3. Thanks in advance

I have a list of travel details where each row is a different leg of a travelers journey. There are common details at the beginning of the row, such as passenger name and such. In order to use the data to auto-fill a templated itinerary I need to align the legs of the journeys per passenger...

I've found dozens of almost answers, but am too ignorant to take the pieces to do what I want. I need to find the last row and the last column and name the range. Many, many postings show getting the last row, or the last column, but not how to use both in the expression. And cautions against...

Hi Guy's I am looking for a little bit of help if possible. I have a worksheet that contain numerous columns of data that has been imported from other worksheets. The columns start at column B and repeat every 3 columns. The number of columns can vary per worksheet. The number of rows can...

Hello everyone! I have been using Mr.Excel for a while and have always been able to find answers to my questions until now. Basically I have a sheet which could have upto 52 columns of data, that are not always in the same sequence. I need to be able to find specific column names and copy the...

Hi, I'm new to VBA and trying to come up with a code for work. I keep a log of accounts with comments and I am trying to create a macro that will allow me to copy old comments from my main sheet and save them in another sheet, to keep a record of all historic comments in the file. I have...

The Function below allows you to return a smaller section of a range provided. Returnable ranges are: - a cell - a range - a row - a column - multiple rows or columns - last row or column - multiple rows at the bottom - multiple columns on the right All I ask is that you LIKE this or post you...

I am working on an inventory spreadsheet and have multiple things that i have working. but the one thing i seem to be struggling with is that i have a sheet "RECORDS" which keeps track of how many of each item i have for the date the inventory is checked which is every other week). what i am...

New to Macros. Trying to autofill format only from E1 to the last column (row1 still). Tried this but it didn't work: Selection.AutoFill Destination:=Range("E1: & LastColumn & 1"), Type:=xlFillFormats I have this above it: Dim sht As Worksheet Dim LastColumn As Long Set sht =...

Hi, I have a table object (in the range A1:M20) with some numbers spread around. I have been using the following code to find the last column, but it always show the last column of the table, event if there is not data (numbers) on the last column. Even if I have numbers only until column B...

I am trying to change the Sub CleanAll() to Sub CleanAll2() but can not get it. Thanks Sub CleanAll() Dim myArray As Variant Dim lastRow As Long With Sheets("360") lastRow = .Range("A" & .Rows.Count).End(xlUp).Row End With myArray =...

Hi, I am wanting to create a macro (which I am hideously new to, sorry), to take the last column from a worksheet (it is a growing worksheet that gets added to daily) and take only the cells which contain text (there are a mixture of text, blanks and numbers) and remove the duplicates. The...

Regarding the identification of the last row or column of a spreadsheet, is it dangerous to use the single line below instead of the lengthy function lastrowN below it? My mind prefers simplicity but if it creates problems.... lastrow = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row...

I have searched through the website and even Bill Jelen's book, but I still cannot find the answer as to how to write the code to find the last column with data in it. I have tried defining a range as seen below, but it's still not working. Any suggestions? finalcolumn = Cells(1...