i.offset0

  1. G

    VBA NOW() Time Stamp - Multiple Columns

    I thought it might be easy to add additional columns to the VBA so every other column produced a time stamp, can someone help please? Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Columns("j:j, l:l, m:m, o:o")) Is Nothing Then For Each i In Intersect(Target...
  2. G

    VBA Time Stamp but only if equalling specific data validation

    Hi, I am not knowledgable in VBA at all. I have found the following that works a treat to time stamp in column J when column K is not equal to nothing. BUT, I want a separate timestamp that will time stamp only when the selection in Column K is specific i.e. "3. Send to Accounts" Private Sub...
  3. D

    Speed Up Macro: Populating tabs based on a variable

    Hello, I have a spreadsheet that puts a stock into a specific tab depending on its industry. The trouble I am having is that I sometimes have 2000 stocks this has to cycle through and it takes a significant amount of time. If anyone can think of a way to speed it up I would appreciate it. Code...
    • dnicholsby
    • Thread
    • 0.pastespecial elseif i.copy i.offset0 paste=xlpastevalues
    • Replies: 11
    • Forum: Excel Questions

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
Back
Top