paste - offset

Posted on 2014-07-31
Last Modified: 2014-07-31

I have an copy/paste
Sheets("Add Delete Team Members").Range("N37").Copy
Sheets("Change Summary").Range("A" & lastTransferRow + 1).PasteSpecial Paste:=xlPasteValues

Open in new window

I want to stamp the next column with username and the next column with date

So the above will drop data into columns A:L, then in:

K: Environ("username")
L: Date

I have the code for username and date, i just need to work it into the paste above

Question by:Seamus2626
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 50

Accepted Solution

Rgonzo1971 earned 250 total points
ID: 40231742

pls try

Sheets("Add Delete Team Members").Range("N37").Copy
Sheets("Change Summary").Range("A" & lastTransferRow + 1).PasteSpecial Paste:=xlPasteValues
Sheets("Change Summary").Range("K" & lastTransferRow + 1) = Environ("username")
Sheets("Change Summary").Range("L" & lastTransferRow + 1) = Date

LVL 35

Assisted Solution

Kimputer earned 250 total points
ID: 40231748
Sheets("Change Summary").Range("K" & lastTransferRow + 1).Value = "username" '(or code to get the username or another variable)
Sheets("Change Summary").Range("L" & lastTransferRow + 1).Value = NOW() '(or code to get the date or another variable)

Author Closing Comment

ID: 40231777
Thanks guys

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question