hide column
 

Will hideing columns affect the way code runs. Or will vba still know the
column is in place. Have code not sure how to change it but relize if I make
worksheets have same nbr columns it will work.
Thanks

hide column
 

Hi Curt,

Normally, it should be possible to construct your code
so that it operates independently of the visible status of
a column.

Try posting the relevant code and explain the problem
that you are experiencing.

---
Regards,
Norman



"Curt" wrote in message
...
Will hideing columns affect the way code runs. Or will vba still know the
column is in place. Have code not sure how to change it but relize if I
make
worksheets have same nbr columns it will work.
Thanks

hide column
 

I have found that in devoloping this for Vet's parade that some columns are
not needed. Am down to having sort column as (C) which of course does not
leave enough columns for code to function. I do not fully understand this
code.As I have never had any training in this. At 70 it is a good time doing
this tho. This does sort in numerical order. If you make changes to doit I
may be able to see what they are and better understand
Thanks Much


Sub AAAA()
Dim cell As Range
Dim rng As Range
Dim rng1 As Range
For Each cell In Range("d8")
Set rng = Range(cell, cell.End(xlDown))
cell.Offset(0, 1).EntireColumn.Insert
Set rng1 = cell.Offset(0, 1).Resize(rng.Count, 1)
rng1.Formula = "=Countif(" & rng(1).Address(1, 1) & _
":" & rng(1).Address(0, 0) & "," & _
rng(1).Address(0, 0) & ")"
rng1.Formula = rng1.Value
Range(cell.Offset(0, -2), cell.Offset(0, 11)).Resize(rng.Count).Sort _
key1:=cell.Offset(0, 1), order1:=xlAscending, _
key2:=cell, order2:=xlAscending
cell.Offset(0, 1).EntireColumn.Delete
Next

End Sub


"Norman Jones" wrote:

Hi Curt,

Normally, it should be possible to construct your code
so that it operates independently of the visible status of
a column.

Try posting the relevant code and explain the problem
that you are experiencing.

---
Regards,
Norman



"Curt" wrote in message
...
Will hideing columns affect the way code runs. Or will vba still know the
column is in place. Have code not sure how to change it but relize if I
make
worksheets have same nbr columns it will work.
Thanks

hide column
 

Error in last post
Want sort to be in column (B) have hidden (B) that is why I said (C)
Sorry

"Norman Jones" wrote:

Hi Curt,

Normally, it should be possible to construct your code
so that it operates independently of the visible status of
a column.

Try posting the relevant code and explain the problem
that you are experiencing.

---
Regards,
Norman



"Curt" wrote in message
...
Will hideing columns affect the way code runs. Or will vba still know the
column is in place. Have code not sure how to change it but relize if I
make
worksheets have same nbr columns it will work.
Thanks

hide column
 

is there any publication that covers code like this for a dummie like me. We
didn't have these machines when I was a kid. Still wondering if hideing
columns effects code operation. (My first post had an error)

"Norman Jones" wrote:

Hi Curt,

Normally, it should be possible to construct your code
so that it operates independently of the visible status of
a column.

Try posting the relevant code and explain the problem
that you are experiencing.

---
Regards,
Norman



"Curt" wrote in message
...
Will hideing columns affect the way code runs. Or will vba still know the
column is in place. Have code not sure how to change it but relize if I
make
worksheets have same nbr columns it will work.
Thanks