Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Appending data with VBA

Hi
I would like to append data after the last occupied cell of a row
using VBA. How do I determine the last cell containing data?
Ta much
Martin
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Appending data with VBA


cLastRow = Cells(Rows.Count,"A").End(xlUp).Row

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mr.mcfly" wrote in message
om...
Hi
I would like to append data after the last occupied cell of a row
using VBA. How do I determine the last cell containing data?
Ta much
Martin



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Appending Data Jordan Excel Discussion (Misc queries) 1 July 31st 09 07:14 PM
Appending Data from one spreadsheet to another GeorgeA Excel Discussion (Misc queries) 4 June 22nd 09 03:11 PM
Appending data from one WB to another WB by date: KR Setting up and Configuration of Excel 0 October 7th 08 03:54 AM
Formula for appending data DS Excel Worksheet Functions 0 August 23rd 05 10:35 PM
Appending data from one sheet to another. Simon Excel Programming 3 November 13th 03 07:32 AM


All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"