Good day

During my work with excel I found strange thing... I cannot name range
containing all 255 columns... When trying to do it from VBA, I have no range
defined, when I try to do it manually, range automatically is reducing to
254 (cut column A)..
Really strange

I tried to google something about it, but no results. It looks, that
microsoft does not allow to do it.. Am I right?

I checked in Excel 2000 and 2003...

Regards
Michal

works for me.

Sub f()
Dim b As Workbook
Dim s As Worksheet
Set b = ThisWorkbook
Set s = b.Sheets("Sheet1")
s.Range(s.Cells(1, 1), s.Cells(1, 256)).Value = "abc"
End Sub

On Wed, 27 Dec 2006 02:41:38 +0100, "Michal AKA Miki"
wrote:

Good day

During my work with excel I found strange thing... I cannot name range
containing all 255 columns... When trying to do it from VBA, I have no range
defined, when I try to do it manually, range automatically is reducing to
254 (cut column A)..
Really strange

I tried to google something about it, but no results. It looks, that
microsoft does not allow to do it.. Am I right?

I checked in Excel 2000 and 2003...

Regards
Michal

I don't seem to have any problem doing this in Excel 2002

Insert/Name/Define
Row 1 Sheet1!1:1

=COLUMNS(Row1) -- 256

Or in VBA:

ActiveWorkbook.Names.Add Name:="Row2", RefersToR1C1:="=Sheet1!R2"
Debug.Print "Row2", Range("Row2").Address

Row2 $2:$2




--ron

hi,
I just tried nameing a range with a macro and had no problem nameing a range
with all 256 columns AND 5000 rows so if a bug exists, its on your pc and not
mine. here is the syntax i used.
Sub Macrotest()
Range("A1:IV5000").Select
ActiveWorkbook.Names.Add Name:="testB", _
RefersToR1C1:=Selection
End Sub
pretty basic.
hope this helped.
regards,
FSt1

"Michal AKA Miki" wrote:

Good day

During my work with excel I found strange thing... I cannot name range
containing all 255 columns... When trying to do it from VBA, I have no range
defined, when I try to do it manually, range automatically is reducing to
254 (cut column A)..
Really strange

I tried to google something about it, but no results. It looks, that
microsoft does not allow to do it.. Am I right?

I checked in Excel 2000 and 2003...

Regards
Michal

You are not running bootleg software are you? Maybe you forgot to make your
last payment on your system and they won't let you use that last colum until
you do.

Just a little afeter Christmas humor!

"Michal AKA Miki" wrote:

Good day

During my work with excel I found strange thing... I cannot name range
containing all 255 columns... When trying to do it from VBA, I have no range
defined, when I try to do it manually, range automatically is reducing to
254 (cut column A)..
Really strange

I tried to google something about it, but no results. It looks, that
microsoft does not allow to do it.. Am I right?

I checked in Excel 2000 and 2003...

Regards
Michal

Others have shown it can be done. If you still have trouble, post a few
lines of your code. That might make it easier to spot the problem.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Michal AKA Miki" wrote in message
...
Good day

During my work with excel I found strange thing... I cannot name range
containing all 255 columns... When trying to do it from VBA, I have no
range
defined, when I try to do it manually, range automatically is reducing to
254 (cut column A)..
Really strange

I tried to google something about it, but no results. It looks, that
microsoft does not allow to do it.. Am I right?

I checked in Excel 2000 and 2003...

Regards
Michal