Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Columns doesnt return expected results
I hope this isnt too much of a newbie question... its been years since I
last did any serious VB programming. I have a body of code that has just finished working with a range of rows set by: Rows(4 & ":" & intLastRow).Select ' select all active rows and now I want to format column A. So I try setting column A to be the active and selected column with Columns("A:A").Select ' select column A however it returns a range of Columns("A:U"). I have also tried Columns(1).Select and Range("A:A").activate with the same results. What am I doing wrong here? Thanks much |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Columns doesnt return expected results
Try
Columns("A:A").NumberFormat = "General" instead of Columns("A:A").Select |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Columns doesnt return expected results
Do you have those bleeping merged cells in column A to column U?
They can screw up lots of things. And to make matters worse, each version of excel seems to treat merged cells differently. Roger Smith wrote: I hope this isnt too much of a newbie question... its been years since I last did any serious VB programming. I have a body of code that has just finished working with a range of rows set by: Rows(4 & ":" & intLastRow).Select ' select all active rows and now I want to format column A. So I try setting column A to be the active and selected column with Columns("A:A").Select ' select column A however it returns a range of Columns("A:U"). I have also tried Columns(1).Select and Range("A:A").activate with the same results. What am I doing wrong here? Thanks much -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Columns doesnt return expected results
Thanks Dave - you nailed it... way down deep in the report there was a
section where A to U was merged. Much thanks to you and a warning to fellow programmers... those merged cells can indeed really screw things up like crazy and yield results that, at first glance, seem to be way out of line with the intended action. Cheers, "Dave Peterson" wrote in message ... Do you have those bleeping merged cells in column A to column U? They can screw up lots of things. And to make matters worse, each version of excel seems to treat merged cells differently. Roger Smith wrote: I hope this isnt too much of a newbie question... its been years since I last did any serious VB programming. I have a body of code that has just finished working with a range of rows set by: Rows(4 & ":" & intLastRow).Select ' select all active rows and now I want to format column A. So I try setting column A to be the active and selected column with Columns("A:A").Select ' select column A however it returns a range of Columns("A:U"). I have also tried Columns(1).Select and Range("A:A").activate with the same results. What am I doing wrong here? Thanks much -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Columns doesnt return expected results
Merged Cells.................the best thing to come along since the Edsel
Gord Dibben MS Excel MVP On Sat, 22 Mar 2008 15:26:36 -0700, "Roger Smith" wrote: Thanks Dave - you nailed it... way down deep in the report there was a section where A to U was merged. Much thanks to you and a warning to fellow programmers... those merged cells can indeed really screw things up like crazy and yield results that, at first glance, seem to be way out of line with the intended action. Cheers, "Dave Peterson" wrote in message ... Do you have those bleeping merged cells in column A to column U? They can screw up lots of things. And to make matters worse, each version of excel seems to treat merged cells differently. Roger Smith wrote: I hope this isnt too much of a newbie question... its been years since I last did any serious VB programming. I have a body of code that has just finished working with a range of rows set by: Rows(4 & ":" & intLastRow).Select ' select all active rows and now I want to format column A. So I try setting column A to be the active and selected column with Columns("A:A").Select ' select column A however it returns a range of Columns("A:U"). I have also tried Columns(1).Select and Range("A:A").activate with the same results. What am I doing wrong here? Thanks much -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
V lookup with 2 criteria to return results for multiple columns | Excel Worksheet Functions | |||
Sumproduct not returning expected results | Excel Worksheet Functions | |||
Round doesnt work the way it is expected | Excel Discussion (Misc queries) | |||
Paste results not as expected | Excel Programming | |||
I need to return mulitple results in several columns please help | Excel Discussion (Misc queries) |