nextrow

  1. M

    My macro requires me to press enter hundred times to run query (how to avoid it)

    Hi All, I am new on this forum. I have recently developed a macro through which I am able to list all files present in the sub-folders. However, there are large number of files (in thousands) and once I run my macro, it wants me to keep my hand on enter key for nearly 5 mins. Can any one tell...
  2. Z

    VB Code help

    I am trying to get my info from my text boxes in my user form into my worksheet. I have done this multiple time before and had easy success but now I'm getting problems. I either gut a runtime error or there is no data transferred. This below transfers no data to the worksheet Private Sub...
  3. K

    userform on VBA

    i have a userform to record my employee info, but i found something error sometimes when i enter a new employee. for instance, i save Leon Wong as the latest in row 6, but column C and so on will interrupt into another row like row 3. here is my code and where am i stuck with? thanks Dim...
  4. P

    VBA code, insert code end of column

    <a href="http://tinypic.com?ref=ega2xg" target="_blank"><img src="http://i64.tinypic.com/ega2xg.png" border="0" alt="Image and video hosting by TinyPic"></a> Sub CopyToAnotherSheet2()'copy and transpose Dim NextRow As Long Dim cpRng As Range Application.CutCopyMode = False...
  5. R

    Stacked If statements

    Hi, I have some code below. it works up to the line calculate cost where it just returns the value from the first if statement. Please help Sub data_sorting() Dim Bcell As Range Dim NextRow Dim I As Integer WS_Count = ActiveWorkbook.Worksheets.Count 'Jan...
  6. F

    For Each cell In Range Copy/Paste Data to another Worksheet

    Hello, I'm having a bit of trouble fixing an issue I'm having and not having much luck googling the problem. I have a loop that searches for certain things. What I'm trying to do is have the row that the search is positive for print the value from Column A of that row into another sheet. I...
  7. D

    Merge cells in column A in function of the number of items written in column B

    Hi all, I’m looking for the lines of code that would allow me to merge cells in column A where the number of cells merged in that column represent the number of items written in the column B. Here is the code of the listbox 1 and listbox 2 that put items from those listboxes in the column B...
  8. F

    Filter Multiple Pivot Tables on Different Sheets Having Different Sources

    Hi Allz, I had help from theBardd to filter multiple Pivots having different sources with one click on a Slicer in this thread. But can any one please help to adjust the following code to link it with a cell instead of a slicer? Private Sub Worksheet_PivotTableUpdate(ByVal Target As...
  9. K

    wrong outcome

    hello all buddies, whats problem with my code below here, how come it returns column I-M with a wrong sequence? (column A-H is correct & prefect) <tbody> I J K L M N DATE CELL PHONE FAX REGION EMAIL expect 15-July-2005 1234 5678 NY abc@hotmail.com the outcome with below code NY...
  10. E

    Macro to copy a data from web

    I am new to macros and VBA, so may ask some stupid question. I want to create a macro that will automatically enter data to a webpage and copy the result and paste to anther web. Now, I am able to let macro to loop through the result which is a table, but can't locate to the data I want...
  11. T

    Excel VBA to Extract Shared Outlook Calendar

    Please forgive me and any help would be greatly appreciated. I am trying to get a VBA to extract a shared calendar from outlook. The below will get my information but I am having trouble finding a way to get another calendar. I've been googling this for a while but most solutions are way over my...
  12. M

    Extracting data & filenames from multiple text files

    I have a folder with 40 text files. The files contain test data from running the same test repeatedly on 8 test units, 5 times in a row. I expect to repeat this testing many times in the future, and so I am trying to speed up the data extraction time versus cutting and pasting. Once the data is...
  13. L

    Run time Error '9'

    I am getting a run time error '9' subscript out of range (in red) and I'm unsure why since it was working and now not working. I obviously changed something but I'm unsure what I did. Any help with this code would be appreciated. Thanks. Sub DistributeFromBiWeeklyPayroll() Dim R As Long...
  14. D

    Error handling in Userform

    Hello all. I created a payroll system in Excel and use a userform to enter employee data. See image below Named controls in order shown: Reg1 (DTPicker) TextBox1 (TextBox) Reg2 (ComboBox) Reg3 (TextBox) Reg4 (TextBox) Reg5 (TextBox) Reg6 (TextBox) When I click on the 'Add To Sheet' button...
  15. V

    vba count emails per day including sub folders

    Hi, I have the code below that outputs the email count per day for a generic team inbox, in this example the inbox is named genericqueries. I am looking for a way to also count the emails in sub folders within this inbox. Also, this email address contains roughly 8000 emails and it takes an...
  16. D

    Macro unique number lookup - exact match required

    Hi All, I am using the following code: Sub ReturnInvoice() Do Dim myWord$ myWord = InputBox("Insert the Voucher Number", "Voucher Search") If myWord = "" Then Exit Sub Application.ScreenUpdating = False Dim xRow&, NextRow&, LastRow& LastRow = Cells(Rows.Count, 1).End(xlUp).Row NextRow =...
  17. N

    Hide Rows with VBA

    Hello, So we have wrote a code that does so many things. But there is a last step we would like it to do. The step is that the data that is being pasted in nextRow=200 and down needs to be hidden. So basically after everything is pasted in the new sheets I would like cells 200 down to probably...
  18. N

    How to use a common template on my code

    So I do I set a template to have information look better? I have wrote a code that creates and renames worksheets based on my list. Each worksheet has Net operating income statements. Now I need these sheet look clean and with a common template. So how do I add a template on top of the code I...
  19. E

    Conditional time formatting

    Please help! I'm trying to set a variable dependent on some input by the user. The user inputs 2 different times; and also selects the date. I need the code to compare these times based on "within an hour AND same day", "outside an hour" AND same day", and "Not same day". It's currently not...
  20. D

    Code reduction exercise

    Hi, I was playing with a very small piece of code, essentially remove rows with X to new sheet and delete from Data sheet. I am trying to see how far I can reduce the code, all three work and it is only a small learning exercise for me. Is this as good as it gets or do you have some advice...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top