endrow

Hey guys, I have three different worksheets. RawDataA RawDataB ReducedData Basically, I only want to take certain columns of data from each of the RawData sheets and comiple them together in the ReducedRawData worksheet. With what I currently have, I am running into issues copying over the...

Hello, below VBA code works for me, i am comparing 2 columns and deleting the entire row if the values are the same. the columns to compare will vary, so i need to add input box(es) so that the user can put in the 2 columns that they want to compare. Sub Delete_Same_City() 'delete row if...

Hello, need advice with the following Quantity is at column 2 and supplier is at column 3. If the quanity is zero do not send the email at that specific supplier I attach the code Application.ScreenUpdating = False Sheets("ORDERS").Select Columns.EntireColumn.Hidden = False...

Good afternoon Could someone provide an explanation why the below endrow variable is not locating the last row of data in it's current position in the script. It stops format before the last row. This maybe an easy one, I am unable to see it. Sub FormatRange() Dim endrow As Long endrow =...

hello all, not sure what to code I need to select the range startrow =2 endrow = 15 startcol=10 end col=50 colstep = 10 for r = startrow to endrow for c = startcol to endcol step colstep set my Range=??? .... any ideas?? Ross

I have a workbook and have et up a macro to send a reminder to outlook, but get a run time error "type mismatch The code below is highlighted .Start = DateValue(Range("D" & ctr)) + TimeValue(Range("D" & ctr)) See sample data and code below It would be appreciated if someone could kindly...

I am trying to incorporate a variable in a CONCATENATE string in a macro. I have a loop that I want to merge 3 values using CONCATENATE with Text1 and Text2 being fixed sources eg A1 & B1 but I need to increment the 3rd value each loop. My variable "ci" is incrementing but I cannot work out how...

Hello Everyone, Question for you. I have been using the following code to hide rows based on a cell value. The macro has worked wonderfully, but today it crashes. Any thoughts would be much appreciated! Sub Hide_All_Rows() Dim sht As Worksheet Application.ScreenUpdating = False For Each sht In...

I need help modifying a VBA code to fill down a formula based on data in another worksheet. Worksheets(2).Name = "Data" EndRow = Sheet1.Range("E" & Rows.Count).End(xlUp).Row Range("A1").Formula = "=TEXT(Delinquency!R[1]C[6],""00000000"")" Range("A1").Select Selection.AutoFill...

I have a macro that I wrote below that is not working like I expected. I do not get a runtime error, but the outcome is not what I desired. I have 2 files; 1 main macro file and a second file that this macro opens. I am trying to delete rows in Col L of the 2nd file based on a value in the...

Hi All I have a document that creates multiple documents in a mail merge type action. I'd like these output as a single PDF for printing later. The code I'm currently running outputs individual documents to a printer. Code is as follows: Sub Test() Dim startrow As Integer, endrow As...

Hello, I have an issue where I have a list on an excel sheet which I need to transpose to put in an array (sheet names) but it loses any leading 0s which means it doesn't recognise the tabs. Dim oWS As Worksheet Dim aSheetnames As Variant Set oWS = Worksheets("Compiler") endrow =...

Hi all, I have written a macro to create pivot tables in a new tab of an Excel 2013 file. The columns (A:AE) will remain static, but the number of rows will vary. For the data source, I would prefer to use a specified range based upon a dimensioned variable named EndRow, something along the...

Hi Excel Experts, Been trying to get the solution for this for weeks but to no avail. I have a table with numbers of column that individually consists of validation lists, conditional formatting and formulas. Am trying to automate the consolidated data from different workbook into a master...

HI, See the table given below. <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>...

Hi. I’ve spent most of this day looking through Excel help and the internet trying to find a solution. I am VERY new at VBA, so please bear with me. I’m using VBA to hide rows in a sheet, and the column that determines whether or not to hide a row has references to another sheet throughout...