Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or
×

Help with Copy Ranges command

More
6 months 1 week ago #1118 by Jay Chivo
Replied by Jay Chivo on topic Help with Copy Ranges command
Hello,
Sorry, we don't have the VBA for this feature.

Please Log in or Create an account to join the conversation.

  • Rafael Melo Viana Lima
  • Topic Author
  • Offline
  • New Member
  • Nouveau membre
More
6 months 2 weeks ago #1072 by Rafael Melo Viana Lima
Help with Copy Ranges command was created by Rafael Melo Viana Lima
Hi,

I'd like to know if there's a way to use the Copy Range commando without needing to open the dialog box every time (keyboard shortcut) or via VBA code.

The problem i have is a range with custom widths and heights where the only solution i found to copy it perfectly was using the copy range from kutools but i need to replicate the same range one bellow another (skipping 2 lines) for more than 100 times.

There's any vba command to execute the kutools copy range function or a faster solution besides opening the dialog box?

Thanks!

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo