python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - worksheet-function

Check column and if condition is True send an email

In the code below I need to check two columns. Column "N" and "O". If I enter an "X" in column O2:O801 I check to make sure there is not an "X" in column N2:N80...
test-img

Devianey26

vba

for-loop

worksheet-function

Votes: 0

Answers: 1

Latest Answer

On error resume next is really not your friend in VBA programming. Try this one, my understanding is that whenever there are two X on a given row an action is triggered: Sub TestMe() Dim t As Lon...
test-img

Vityata

why do I get object doesn't support this property or method?

for some reason MsgBox (VarType(Application.WorksheetFunction.Address(1, getRowOfTestCode, 4, 1))) where getRowOfTestCode = 13 throws the error 438 "object doesn't support this property or met...
test-img

Kevin Freiges

excel

vba

worksheet-function

Votes: 0

Answers: 1

Latest Answer

Address is not available in VBA via WorksheetFunction You can instead use something like Cells(rowNum, colNum).Address(False, False) It's not clear from that one line what the context is for this th...
test-img

Tim Williams

Excel Formula to compare single cell value with the whole column and return the value for a particular row where match found

I need to compare the B2 Cell value (6012469) with Column A i.e. cell A2 to A10 and return the b2 cell value (6012469) in column C where the value matches i.e. cell C5,C7, C9 AND C10 and NA in remaini...
test-img

sampu

excel

vba

worksheet-function

Votes: 0

Answers: 1

Latest Answer

Select any cell inside your data range in Column A. Go to your ribbon, click Home > Format as Table. It doesn't matter what colour scheme you choose. Make sure that all your data in Col A plus Col...
test-img

stifin

How to fix code to save all worksheets as one PDF? VBA

'How to fix code to save all worksheets as one PDF from the open workbook? VBA. It only prints the active worksheet right now for some reason. Sub abc() For i = 1 To Workbook.Worksheets.Count With Act...
test-img

borna

excel

vba

pdf

worksheet-function

worksheet

Votes: 0

Answers: 1

Latest Answer

I did this very same thing just a few days ago. Try it like this. Worksheets(Array("Sheet1", "Sheet2")).Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ &q...
test-img

ASH

Posts

Questions

Blogs

Jobs