Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

exclude columns

  Asked By: Bara    Date: Feb 24    Category: MS Office    Views: 816
  

I want to exclude some columns from the report which i am generating
using excel vba ...


The first row of excel sheet has all the column names..


Iam writing a code something like

Arrcols=("col1","col2","col5")

If cells(1,k).value =arrcols(i)

code...

End if


I want that if the col name is between the arrcols range then it
should be excluded form the further line of codes..

however its giving syntax error

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Jonah Brown     Answered On: Feb 24

To understand what is going wrong we need to see more of your code,
preferably the whole sub.

What line  of code  gives the error? What is the error  message?

 
Didn't find what you were looking for? Find more on exclude columns Or get search suggestion and latest updates.




Tagged: