Excel VBA Other Sheets Not Reflected

What I want to solve

Excel VBA Does Not Reflect Data Extracted from Other Sheets

Problems and Errors Occurred

I would like to extract the data of Excel sheet from other sheets, but the data using '=' is not reflected.Is it a problem to have other data in the same cell?

Actual code:

BASEDATE >= TO_DATE('Original sheet!G7’,‘YYYY/MM/DD’)

What I tried myself

Unquote Single

I would like someone to give me a clue.Thank you for your cooperation.

vba excel

2023-03-27 19:06

1 Answers

Dim BASEDATE As Date
Dim TO_DATE As Date
BASEDATE = #2023/03/31# 'Subscribe Date Type Value
TO_DATE = CDate(Sheets("Original Sheet").Range("G7").Value") 'Convert string to date type
If BASEDATE >= TO_DATE Then
    If BASEDATE is TO_DATE or higher, do something
End If

2023-03-28 17:30

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656