-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
toprow
-
B
Sort leading to debug error... any thoughts?
I have the following code working as part of a macro without any issue... of course, when I get to my client, I get a debug error... The topRow and botRow variables are storing numbers and in debug mode, when I hover over them, the correct numbers are showing. Any thoughts on a better way to...- braindiesel
- Thread
- botrow debug numbers thoughts toprow
- Replies: 1
- Forum: Excel Questions
-
P
Changing VBA code from 'Paste' to "Past Special > Values"
Hi there, I have the below code which I need to change so it pastes values. Any ideas?? Option Explicit<code class="xml plain" style="white-space: nowrap; padding: 0px !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; font-size: 1em...- Petehab
- Thread
- dim leftcol numareas range toprow
- Replies: 1
- Forum: Excel Questions
-
H
Just trying to loop this. Already works but manual
Hi, Just working on a random process to improve, and I am simply not used to looping enough to be able to integrate it. Hoping someone might be able to help. The code below is currently working, if I run it manually step by step. I start in A1. I then find the first "br :", and copy it, and...- hitbid
- Thread
- autofill bottomrow end finding_bottom_and_top toprow
- Replies: 1
- Forum: Excel Questions
