Converting a sub to a class

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

Solved

Post Body

Hi everyone, Im really new to VBA and I dont understand most of the things. However, I am asked to change a particular part of my code.

I have a main action that verifies whether an action meets a particular criteria and when it does it should call another sub that will perform a copy & paste of data. Now what they want me to do is to move the code that is responsible for selecting data, copying, and pasting to a class.

Something like:

If (Range("E" & i).value = "CopPas") then Call CopPas <-- I get error here saying "Sub or Function not defined"

Author

Account Strength

100%

Account Age

5 years

Verified Email

Yes

Verified Flair

Total Karma

11,280

Link Karma

810

Comment Karma

9,750

Profile updated: 5 days ago

Posts updated: 6 days ago

CainMiyamura

Subreddit

r/vba

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 2 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/vba/comment...