LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 106
Default Syntax to select all data

Let me start off by saying I have some programming experience, but am very
new to VBA.
I want to create a macro that will select a range of data, sort it, insert
new lines, and take the sum of the parts. Where I'm hung up on, is that the
data won't always be the same length. I know it will always be the same
width, so the column is not a problem, but how would I go about finding the
bottom-right cell of data? I believe I know how to find the last ROW of
data, but not the specific cell.
 
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
VBA: Column Select then Data Select then return to cell A1 James C[_2_] Excel Discussion (Misc queries) 3 February 1st 10 11:35 AM
VB Syntax to select a range xjetjockey Excel Discussion (Misc queries) 4 January 17th 07 03:12 AM
Range.Select Using Variables - need syntax gradientS Excel Discussion (Misc queries) 3 February 16th 05 12:45 PM
Select Case syntax Susan Hayes Excel Programming 2 December 4th 04 10:42 PM
Syntax for Excel variable using a SQL Select/From/Where Command... Chip Pearson Excel Programming 0 September 8th 04 11:15 PM


All times are GMT +1. The time now is 08:17 AM.

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

About Us

"It's about Microsoft Excel"