.cellslr

  1. H

    Need help on VBA Excel to copy paste value

    Hi, i had a code. How to copy paste value? Application.ScreenUpdating = False With Sheets("path") 'Source worksheet name Set DestSh = Sheets("FileCopy") 'Destination worksheet name lr = .Cells.Find("*", , xlValues, , xlByRows, xlPrevious).Row...
  2. R

    Paste Special Values

    Is there any way to make this vba code paste special ? Sub MoveCols() Dim lr As Long Application.ScreenUpdating = False With Sheets("Insert Data here") lr = .Cells.Find("*", , xlValues, , xlByRows, xlPrevious).Row .Range(.Cells(2, "A"), .Cells(lr, "A")).Copy...
  3. F

    Multiple Private Sub

    Hello, im VBA newb. Please how could I combine this two sub? Private Sub Worksheet_Change(ByVal Target As Range) Dim rInt As Range Dim rCell As Range Dim tCell As Range Set rInt = Intersect(Target, Range("AE:AE")) If Not rInt Is Nothing Then For Each rCell In rInt...
  4. F

    VBA audit trail - modifications

    Hello, pleas, how I could exclude changes of blank value? I no need log, when emty cell is changed. Thank you! Dim PreviousValues As Variant Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Store current values of all cells Application.EnableEvents = True...
  5. C

    Array Selection from Closed Workbook

    I have a formula that selects an array and then pastes into a database on another worksheet. Is there a way that the array selection can be from a closed workbook, and then paste the data into the database on my open workbook? This is my code currently: Sub CopyData09() Dim lr As Long, i...
  6. F

    Change Log Tracking

    Hi all. Thank you, in advance, for your help. I found this code to track any changes made to each tab. I have a table in columns A-AV (different rows for each tab, depending on the data). Is there anyway to update this code to not track when rows are inserted? Additionally, how would I write...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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