I'm trying to clear a range and then paste data from the clip board
into the worksheet.
The data on the clip board is copied from another application.
Ive tried the script below without success.

I hope to find it resourceful!

is it posible to have a spredsheet with more than 256 columns ?
i need to make a spredsheet with 365 columns (1 year)
thanks

I wish to learn Excel Visual Basic for Application

Kindly suggest how to creat filter list to avoid from same or repeatd entries in a column.
Example
Column "A"     Column "B" (Filter List)
RB000001009    RB000001009    

Hi there...
What I´m trying to do its pretty simple, but not to me.
i m havin 2 sheets in excel. in one of those UNIQUE records are there wit
some corresponding values in another column.... bt in another sheet there is

I apologize in advance if this is posted in the wrong group, I am
unsure as to which excel group this would be best in.
I export my bank statements into excel each month. They have five
columns:

I have 150 names in Sheet 1 from A1 to A150
also i have 151 sheets in the workbook
I want names to automatically appear in sequence for e.g.
- The name in A1 of Sheet 1 - should appear in A1 of Sheet 2

Anyone know how to create a file which when opened by Excel 2003 causes it
to redirect itself and open a second (csv) file? I know how to get a web
browser to do this using http-equiv="REFRESH" but cannot do it within Excel.
Many thanks

Is it possible to open with Excel 97 an  Excel 2003 file  which
include a choice list ?
Great thanks

I have 2 ranges.  Column A1:A1000 reads the values of column B1:B1000.
In other words, A1=B1, A2=B2 and so forth.  For example, if I delete
the contents of A5 or enter a different number in A5, not only have I
deleted the value of B5 as reflected in A5, but I've also deleted the

If I merge cells from A1 through I20, I can wrap text only through row
11 and not the full 20 rows.  Excel appears to have a limit.  Is there
a function or macro that will increase the amount of text that can be
entered?  Thanks.

I'm trying to learn a little about pivot tables and am looking for a
larger spreadsheet than I care to build. Is there a link where I can
get a reasonably large sheet with a lot of data?
I seem to remember that I used to have one that I thought came from MS

I have a procedure in visualbasic that delets spreadsheets from Excel
workbook.
if there's data on the spreadsheet, Excel is asking to confim the delete
operation by a yes/no message box.

I'm looking for a link to sample data for Excel. I have a project that
I'm working on but would like to have a larger data sample to play
with. And a decent size sample would be nice to work with for Pivot
Tables and the link, something to learn from.