irow

HI All, I want to do the following things with the help of conditional formatting. 1) if cell is blank - no colour 2) if cell value is greater than 5% cell should be blue 3) if cell value is less than -5% cell should be blue I am using below code however I am not getting the results , could...

Hello! I have a "Ship" button with a macro that copies filled out rows in an order form and adds them to a list of shipments in another workbook. In Workbook A, there is a table of part numbers and their quantities, referred to in the code as iRow. Sometimes I have to make partial shipments, so...

Hi, Please help how to add border when copying information to the sheet. ( Selection.Borders(xlDiagonalDown).LineStyle = xlNone) Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("Sheet1") Set ws1 = Worksheets("Sheet2") 'find first empty row in database iRow = ws.Cells(Rows.Count...

Hello! I have created a template Order Form that a user is to fill out. When they are done, they click a "Ship" button. That button opens up a workbook with a list of all of the Shipments placed through clicking that button and adds the new parts being ordered to the list. In addition, the...

Hi, Please see below code. When I run macro, info copying to sheet1. But I need at the same time to copy same information to sheet2. Please help. Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("Sheet1") ws.Cells(iRow, 2).Value = Me.combobox_name.Value

I can't seem to figure out why I am getting the runtime error 1004 (Application defined or object defined error) For iRow = 2 To lrow wsA.Cells(iRow, IDcol + 2) = WorksheetFunction.VLookup(wsA.Cells(iRow, IDcol + 1), wsB.Range("$A$1:$D$3000"), 3, False) Next iRow Thanks.

Hi All, I am trying to approach this from a different angle, the below code is a watered down version of what i ask trying to create, where a form is used by a single use on a windows machine running IE where the output of the form sends the data to a single excel sheet. The text box works fine...

Morning All, What i am trying to do is create a single web page that has text fields and radio buttons to allow a user to input data using a touch screen prior to hitting a submit button and for that data to be sent to a single excel file. I found the following code during my google research on...

I have some relatively small HTML files, pretty much plain text in UTF-8 format. But no matter what I'm unable to get to load into a string. I've scanned everywhere Microsoft own help documents are pretty US. I could use copy/paste, but there is no fun in this, and also I have 200+ files which...

Hello, I've been trying to figure out how to select a range based on the last column and last row of data. I need a code that will look for the word "Technology' in column L. Once it finds that word, I need it to select all data from column A to P. Copy that data and paste it into cell K22...

Hi All, Been using this, but need for it to include contents within subfolders, and can't figure out how to do it. Any one suggest the way / provide a steer? Also, is it possible to add a column with details of the last user to save it, or access it? - not sure if that data is held with the...

Hello, Can anyone help me tweak the code below? I am using this code to insert a row beneath the header once it finds "Audit_Name". The code works and it does insert the blank row. However, since the header is shaded blue, I need the new row to be in grey (RGB 217,217,217) OR White...

Hi All, I m using below code for merge sheet but its asking for clipboard while paste every file (there is a large amount of information on the clipboard,Do you want to be able to paste this information in to onother program later?. I have 20K to 40K rows in every sheets.Please help Sub...

Hello, I have the following workbook macro that lists all files/folder names from a directory. I would like to exclude all folders from being listed (the only folders that would be in this directory would be .zip folders). Ideally I would not want any folders to be listed in the workbook...

I have seen examples of this issue out there, but i am having problems solving it when it comes to solving my own. Please take a look at my code below, it is bugging in the array formula. Dim TableNames As Worksheet Dim ss As Worksheet Dim ssclaim As Worksheet Dim sspercent As...

Hello, I've been able to find a couple macros posted elsewhere to accomplish what I'm looking for, but it does not work for all instances with items on the last row and was hoping somebody here could help me refine the macro or suggest an alternative solution. Here's the code: Sub AddBorders()...

Hello, First-time poster here, so please help me if I'm not doing something quite right. I am a manager of a workbook that tracks our Global Complaints at our company. This file has a Master Sheet where we list every complaint and then 5 other worksheets where I present the information...

Greetings all, I have the following code: iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _ SearchDirection:=xlPrevious, LookIn:=xlValues).Row + 1 I have three inputs Agent name, QA score, and Date. How would I change the above code to automatically enter the QA score and Date data...

Hey guys I use a spread sheet with a macro built by someone who left my team a year or so ago - Up until now I've had no issues with the Macro. The macro pulls data from a mailbox in Outlook when you click a button within the spread sheet. We have recently moved to Windows 10 and I've been...

Hey guys I use a spread sheet with a Macro built by someone who left my team a year or so ago - Up until now I've had no issues with the Macro. The Macro pulls data from a mailbox in Outlook. We have recently moved to Windows 10 and I believe that is when the Macro has stopped working...