473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Excel with VB filtering inquiry

1
Hello everyone,

Good Day!

I am new to posting, forums and I would like to ask for help.
I have been working on this assignment in Excel. I have tried to create button on top of my worksheet that will filter the desired category but it run so slow

see below the code.

Private Sub CommandButton1_Click()

Rows.Hidden = False
Counter = Range("A1").Value + 4
For i = 4 To Counter
If Cells(i, 14).Value <> "CJSL" Then
Rows(i).Hidden = True
End If
Next

End Sub



If someone can help me enhance my excel vbcode to make it faster it would be extremely appreciate it. If not can someone direct me in the right direction.

Thanks Everyone,
Manne
Aug 4 '07 #1
1 884
bartonc
6,596 Expert 4TB
You'll probably want to repost in the Visual Basic Forum for faster response. And while you are browsing the site, check out our Posting Guidelines. Thanks.
Aug 5 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Bajal Mohamed via SQLMonster.com | last post by:
I am facing problem like; We generate reports thru Excel Pivot table. The data is coming from sales cube. Let?s assume that there are 2 products A and B. The user wants to filter for each...
10
by: Robert Hicks | last post by:
I need to pull data out of Oracle and stuff it into an Excel spreadsheet. What modules have you used to interface with Excel and would you recommend it? Robert
3
by: Conrad F | last post by:
Hello All, I know how to import a specific named excel sheet into a datagrid using ADO.NET by setting up a JET connection and then SELECTing data from the sheet. However, for a real world...
8
by: Radu | last post by:
Hi, I have the following problem: I open a recordset based on excel/csv files, but then I need to filter (in code) in order to extract only data pertaining to a specific person. This code is...
3
by: JohnM | last post by:
I can transfer my data from a table into an Excel Spreaadsheet with DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Whatever", "Whatever" This saves the spreadsheet and the user...
3
by: Mahesh83 | last post by:
Hi my code is <? $header = "Company Name". "\t"."Inquiry Date". "\t"."Contact Person". "\t"."Email ID". "\t"."Address". "\t"."City". "\t"."State"."\n"; $data = ""; ...
2
by: nofear | last post by:
I used to export my reports as snapshot but now I have to export them to Excel When I export my report to a Excel Spreadsheet the report header and footer are not included Only the data gets...
6
by: nairda | last post by:
Hi there, I need help processing data from Excel in VB. I have a MSHFlexgrid to show data extracted from Excel. I'm able to show a range of cells from Excel table to my Flexgrid, but that's it. The...
9
by: AGP | last post by:
I have a VB6 application that has an OLE container with an embedded Excel chart. Our office updated to Excel 2007 and now although the app works the charts looks like crap. Since the app is fairly...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.