[Webinar] Streamline your web hosting managementRegister Today


Avoiding .select with offset

Posted on 2008-02-08
Medium Priority
Last Modified: 2013-12-26
Hi guys.

How I can avoid using select when I want to use offset? Because using select sometimes cause errors. So, how to rewrite sth like this:

Worksheets("one").Cells(2, 2).Select

ActiveCell.Offset(4, 0) = Worksheets("two").Cells(7, 4) & " " & Worksheets("two").Cells(7, 3)
Question by:spandor
1 Comment
LVL 48

Accepted Solution

Wayne Taylor (webtubbs) earned 1000 total points
ID: 20857998
Use this....
Worksheets("one").Cells(2, 2).Offset(4, 0) = Worksheets("two").Cells(7, 4) & " " & Worksheets("two").Cells(7, 3)

Open in new window


Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month8 days, 18 hours left to enroll

590 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