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: 1
Default Help on macro output

Hi all,
with pain, blood and a friend I've written a simple macro, but, due
to my inexperience I can't position the output result where I want. The
string that place the output of the if loop is this one:

For i = 1 To 5

Worksheets("sheet2").Cells(65536, i).End(xlUp).Offset(1, 0).Value
= .Cells(l, i).Value

Next

The problem is that this string place the output from the A2 cell
placed in sheet2. If I'd like to place the output from A10 or let's say
F10 in sheet2, how I have to write the string?

Many thanks and kinds Regards

--
--
Live Long and Prosper
Xerses / Antonio from work

 
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
Create Excel macro for barcode output hugo Excel Discussion (Misc queries) 1 March 4th 05 04:52 PM
need macro to output quatation mark... cdde[_4_] Excel Programming 1 November 9th 04 01:06 AM
Need help with report output....macro??? shane476 Excel Programming 1 July 29th 04 10:17 PM
Macro to match output from 2 columns... [email protected] Excel Programming 5 July 16th 04 08:39 PM
Trying to protect output file with Macro Vasant Nanavati Excel Programming 0 June 2nd 04 01:23 AM


All times are GMT +1. The time now is 10:24 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"