loop/ if statement needed

Status
Not open for further replies.

Asche

Board Regular
Joined
Jun 25, 2008
Messages
50
in the row 'A' is the only row I am working in at all.
I have code to copy something from a text.txt into the excel document.
but I need some code to have it check A1 to see if there is data in it. if so I want it to go to A2 check A3 and so on till it finds the first cell with no data in it.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Asche

Board Regular
Joined
Jun 25, 2008
Messages
50
gave me an error. mite be the excel I am useing.
useing win2000.
and also that code starts from the last cell in the workbook. not from the top.
 
Upvote 0

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,961
Office Version
  1. 365
Platform
  1. Windows
You should continue in the original thread rather than start a new one.
Continuing in original post.
 
Upvote 0

Asche

Board Regular
Joined
Jun 25, 2008
Messages
50
sorry. but this one is here now. I will make note of that for future reference.
 
Upvote 0

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Please post the exact code that you are using and indicate the error message and on which line the error occurred.
 
Upvote 0

Asche

Board Regular
Joined
Jun 25, 2008
Messages
50
I completly redid the code but I will paste it back in and try again.

it sticks it in c column but I'll try to mess with it till it works
 
Upvote 0

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
66,969
Office Version
  1. 365
Platform
  1. Windows
Per forum rules, please do not start new threads on the same question. They will be locked.

Please continue on in the original thread.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,191,090
Messages
5,984,572
Members
439,896
Latest member
SquareCare

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top