How do I code this in VB?

Question

1.00/5 (1 vote)

See more:

I want to take a row from a tab in an excel spreadsheet and put in another tab on the next available row. I think I need to have a pointer going up in value by one every time a row gets filled?

What I have tried:

recording a macro but obviously dont know how to override the code with a pointer feature

Posted 24-May-23 2:12am

0419825184

Updated 25-May-23 13:50pm

Add a Solution

Comments

Graeme_Grant 24-May-23 8:19am

the VBA generated is an example of what you need to code. If you don't understand what is generated, then you need to learn to understand. We are here to give you direction, not write your code for you. If we do it for you, you will not learn. Google and YouTube are good places to start.

0419825184 24-May-23 8:21am

You are right of course! I'm close to figuring it out, I can feel it...but head wrecked with it!

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2023-05-24T03:58:00

I find this site useful for my students learning VBA - Excel Macro Mastery[^] There are lots of worked through examples and he explains the principles very well.

If you prefer to learn from videos he also has a YouTube channel - https://www.youtube.com/channel/UCLsnK4MPVaqiVx3DSEqbb1A[^]

Be aware there are numerous adverts for you to buy his book and/or courses - there is no need to part with your money!

This video might be one to help you with this particular problem - How to get the Last Row in VBA(The Right Way!) - YouTube[^]
And this one will help you with moving the data How to Use Arrays Instead of Ranges in Excel VBA - YouTube[^]

Hint - because you have recorded a macro you are likely to be using Cut & Paste - don't!

cmarcotte · Answer 2 · 2023-05-25T13:50:00

It is very easy to copy and paste ranges in Excel and in Excel VBA. You only need to record your macro using appropriate Keyboard shortcuts.

XlDirection enumeration (Excel) | Microsoft Learn[^]

Keyboard shortcuts in Excel - Microsoft Support[^]

Getting started with VBA in Office | Microsoft Learn[^]

How do I code this in VB?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0