.cellsrows.count

  1. T

    Optimizing Code

    I have this code i'm using to extract multiple tabs into one. Is there a better way to run this? Any help would be appreciated. Sub PullData() Dim i As Double Dim wscount As Double Dim imaxrow As String Dim Datastart As String Dim lowrow As String Dim uprow As String Dim x As Double Dim Ship As...
  2. Maraua

    Copying non-adjacent columns to other sheet

    Hi, I have the following code that copies filtered data from one sheet to another. I use the copied data to populate a listbox on a userform: With ws .AutoFilterMode = False Set rng = ws.Range("B8:R8" & .Cells(Rows.Count, "B").End(xlUp).row) rng.Copy...
  3. O

    VBA to compare a range of values against another in different sheets

    Hi everyone! Am new here and would appreciate some help. I have 2 sheets (Sheet 1 & Sheet 2) and would like to populate a portion of Sheet 2 with just 6 columns from a whole bunch of data I am updating manually everyday in Sheet 1 with a click of a button. However, there are some information...
  4. U

    ComboBox AutoWordSelect issue?

    When debugging, UserForm ComboBox1 and 2 will “auto select” the names in the ranges. I can enter the first letter in the ComboBox and the item is displayed, in this case, Range R is a list of cities, Range S is a list of States. When the UserForm is run LIVE, I must enter the entire city or...
  5. B

    Copy and paste vba need help

    Sub STEP2() Dim Lastrow As Long Dim Lastrow2 As Long Dim Lastrow3 As Long Dim Lastrow4 As Long Dim Lastrow5 As Long Dim Lastrow6 As Long Application.ScreenUpdating = False With Sheets("amir") Lastrow = .Cells(Rows.Count, 2).Row Lastrow2 = .Cells(Rows.Count, 7).Row Lastrow3...
  6. R

    Attendance append not working

    Hello Everyone, Its been a while since my last visit. I have been working on the my VBA skills. I have a workbook with two sheets. I have written a code to append the data from one sheet to the other. But it is not working as desired. Any help or suggestion related to the issue is much...
  7. A

    VBA to multiply column by two different amounts based on date

    I hope someone can help with this. I can't find anything on the web to help and everything I have tried fails. I need to multiply the figures in column L by 50 if the date in column A was before 01/04/2018 otherwise multiply it by 60. Here is the existing code which I was using prior to...
  8. R

    Copy from one workbook to another

    I have a workbook where I need to copy data in a workbook (SAT_Marzo.xlsm) from B3 to the last cell containing data and paste this into a different workbook (CONTABILIDAD TOTAL 2018.xlsm) in the first non empty cell of column C. This is the code I have presently where I am able to select the...

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