irow

Hello, I am trying to use a Do loop for the first time and having some difficulty I want to exit the Do loop when .Cells(irow, icol) = "" and advance to the next row My code only works for the irow = 2, it does not advance i.e. next irow does not seem to be read or executed The For loop is...

Hi all, I haver the following code that inserts a blank row into the data when the reference changes in column C Is there a way for this to work with ONLY visible data (ie there may be hidden data) Many thanks for any info Sub AddBlankRows() ' Dim iRow As Integer, iCol As Integer Dim oRng...

Hello all. I've been searching for several days and trying different techniques with no apparent success, so I'm hoping someone can see what I have and have a better solution. The most comprehensive, succinct, and successful code I've been able to construct with the help of many, is the example...

Hi I have a sheet called "Data" and from cell A2 I have many numbers like: 30023 30028 30102 30001 and so on, but in the same list the number can apper many times like 30023 30028 30001 30023 30089 30001 So my question are, how can I fill a combobox, the list of number but if the number...

Hi all, First off, I'm not a programmer, I just Mr Magoo my way through this stuff, copying and modifying stuff I find online. I hate to be the guy that signs up just to ask a question but after a day of searching and messing around, I'm still lost. So, thanks in advance!! I have a macro...

I hope someone can help me with this as it's driving me nuts. iRow 3 and 4 are time values that may span more than 1 day. For some reason the line of code in red, puts FALSE in the worksheet cell. I have posted the whole procedure so you can see what is going on. Private Sub btnUpdate_Click()...

Hi, If the user makes a certain change, I have a worksheet level macro that makes some formatting changes. The macro works well. Unfortunately, whenever it runs, the user loses the ability to Undo. Is there either: i) a way to keep the macro, but preserve the ability to undo, or ii)...

Hi all, I found and adapted the below macro which works perfectly for me. However, I now need to add in a new column which provides the attachment name(s) on any of the emails and having tried an assortment of variations, I am not getting anywhere in the dimensions and sets to use. Can anyone...

Hello there. Forgive me as i am new to forums. I have been trying to find a way to fix my Excel 2010 userform for 3 days now and am getting desperate! I am creating an order number system, that is accessed from one document; New Order Number System.xlsm. I have created the userfrom, got all the...