Posted to microsoft.public.excel.programming

ScottM

external usenet poster

Posts: 4

programatically selecting columns

Hi,

I am writing a macro to import multiple text files into a spreadsheet. The
only part I haven't figured out is how to step sideways, i.e the first text
file should use A1 as its origin, the second file C1, the third E1 and so
on.

Range(A1).Select
Range(C1).Select
Range(E1).Select

/Scott

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
programatically selecting columns to import text into	ScottM	Excel Discussion (Misc queries)	2	November 25th 05 05:41 PM
Selecting Columns	Shatin[_2_]	Excel Programming	4	September 7th 05 01:07 PM
VBA Range Issue : Cannot programatically select more than 42 columns	Learner[_3_]	Excel Programming	4	January 31st 05 09:55 PM
Selecting columns	aspadda	Excel Programming	1	December 9th 03 03:56 AM
Selecting Columns	xnman	Excel Programming	2	November 18th 03 01:52 PM

All times are GMT +1. The time now is 01:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us