VBA DEVELOPER WORLD

Welcome to VBA Tips & Tricks. All VBA related information will be posted on this blog. Of late, VBA has been disregarded by many software professionals for .Net, c# and other technologies. This blog will also post articles related to them too Happy reading

Friday, December 2, 2011

Active Cell

An active cell is the current cell that is selected. This term is used in many macros. This can be used as a marker. A good example is when you need to move from your current cell. Refer to Moving your cursor macro.

Sheets("sheet3").Range("A1:A3").Copy Destination:=ActiveCell
Posted by VBA DEVELOPER at 6:06 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2013 (16)
    • ►  March (4)
    • ►  February (5)
    • ►  January (7)
  • ►  2012 (56)
    • ►  December (6)
    • ►  November (5)
    • ►  October (5)
    • ►  August (5)
    • ►  July (5)
    • ►  June (5)
    • ►  May (5)
    • ►  April (5)
    • ►  March (5)
    • ►  February (5)
    • ►  January (5)
  • ▼  2011 (50)
    • ▼  December (8)
      • Duplicates (Highlight duplicates in Bold Red)
      • Deleting Empty Rows
      • Current Cell Content
      • Current Date
      • Counter
      • Copying A Range
      • Counting Rows & Columns & Sheets
      • Active Cell
    • ►  November (12)
    • ►  October (5)
    • ►  September (5)
    • ►  August (5)
    • ►  July (5)
    • ►  March (5)
    • ►  January (5)
  • ►  2010 (72)
    • ►  December (5)
    • ►  November (7)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (6)
    • ►  June (5)
    • ►  May (5)
    • ►  April (10)
    • ►  March (5)
    • ►  February (5)
    • ►  January (5)
  • ►  2009 (10)
    • ►  December (8)
    • ►  November (2)
  • ►  2007 (2)
    • ►  November (2)

About Me

VBA DEVELOPER
View my complete profile
Simple theme. Theme images by luoman. Powered by Blogger.