C
crapit
Wat do I use to detect cell contain the word "Actual" and assign the row to
a variable which I can use latter on?
a variable which I can use latter on?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
you may explain with some more detail what you mean with 'variable
assignment' and what you want to do later on
you may explain with some more detail what you mean with 'variable
assignment' and what you want to do later on
C
crapit
I want to use it to hide the entire row of the cell if it contain the word
"Actual"
"Actual"
F
Frank Kabel
Hi
try the following macro:
Sub hide_rows()
Dim lastrow As Long
Dim row_index As Long
Application.ScreenUpdating = False
lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For row_index = lastrow - 1 To 1 Step -1
If Cells(row_index, 1).Value="Actual" then
rows(row_index).hidden=true
End If
Next
Application.ScreenUpdating = True
End Sub
try the following macro:
Sub hide_rows()
Dim lastrow As Long
Dim row_index As Long
Application.ScreenUpdating = False
lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For row_index = lastrow - 1 To 1 Step -1
If Cells(row_index, 1).Value="Actual" then
rows(row_index).hidden=true
End If
Next
Application.ScreenUpdating = True
End Sub
C
crapit
It doesnt work if there is at least a merge cell on the same row, how to
remedy?
remedy?
C
crapit
Updated, it doesnt work at all!
crapit said:It doesnt work if there is at least a merge cell on the same row, how to
remedy?
F
Frank Kabel
Hi
what do you men with does not work?
This searches for the value 'Actual' in column A and works for me
what do you men with does not work?
This searches for the value 'Actual' in column A and works for me
C
crapit
The rows are not hidden
Frank Kabel said:Hi
what do you men with does not work?
This searches for the value 'Actual' in column A and works for me
F
Frank Kabel
Hi
if you like email me your file
if you like email me your file
C
crapit
I get wat you mean, but only cell A1 can be detected, but i have quite a
number of cell that contain "Actual"
number of cell that contain "Actual"
F
Frank Kabel
Hi
now I'm confused?. The code should run through column A and hide all
rows which have the text 'Actual' in column A. If this is NOT what you
want please describe with more detail what you expect
now I'm confused?. The code should run through column A and hide all
rows which have the text 'Actual' in column A. If this is NOT what you
want please describe with more detail what you expect
C
crapit
it only hide row 1 if "Actual" is found on cell "A1"
F
Frank Kabel
Hi
then please send me your testfile
then please send me your testfile
C
crapit
I cant due to confidential purposes. Anyway, does ur macro refer to column
'A' only?
'A' only?
C
crapit
Anyway, I had roughly figure out how it work! How do I calculate the total
no, of worksheets in a workbook?
no, of worksheets in a workbook?
N
Norman Jones
Hi Crapit,
Activeworkbook.Worksheets.Count
How do I calculate the total no, of worksheets in a workbook?
Activeworkbook.Worksheets.Count
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.