Hi Hemant,
I tested the code and made few changes as needed but still it says "For/Next
loop not Initialized", where are we wrong in below code, please advice.
*Sub test()
j = 1
While j <= 65000
For i = 2 To Worksheets("Replace_Values").Cells(65000, 1).End(xlUp).Row
If Worksheets(1).Cells(j, 2) L
1) Sure. You just need to describe your logic.
For instance:
"choose # from bank 1 and # from bank 2"
OK, on the "Make Test" sheet, add a line for the number
from each "bank"
(A1 is # required from bank #1, A2 is # from bank #2)
Then, define QRequired1 and QRequired2
(Dim QRequired1, QRequired2
@Rolf ... Thank you very much... You were a BIG BROTHER to me, teaching me
in detailed patience how to make my first steps in walking to macros. I
tested my codes with ALL your suggestions and it went fine. May you be
blessed with good health and long life.
On Wed, Oct 28, 2009 at 11:20 PM, Rol
Great, that works a treat. I have a couple of questions...
1) Could I easily get the test to be drawn from more than one bank of
questions - ie choose 5 from bank 1 and 10 from bank 2 - in order to
give me a little more control over the level of the test?
2) Can I add a button or is there some o
Wow - thank you so much. I'm going to give this a go later this
evening and I'll let you know how I get on. I am totally new to this
so am sure I'll have a question or 2!
Thanks
On Oct 28, 12:05 pm, Paul Schreiner wrote:
> As with any question, there are as many
> approaches to an answer as the
I created a pivot table, for some selection, it will display a certain
number of rows and columns. However it will resize itself
automatically (i.e. will not display empty columns). This is quite
annoying as I have formulas referencing the pivot table. Is there a
way to force the pivot table to
Ooops! I forgot to mention that I introduced another constant for the
'Period' column (PERIOD_COLUMN) in your Computation worksheet. Please
add this declaration at the top of your VBA module:
Const PERIOD_COLUMN As String = "E"
Doing this is not really required, but it typically simplifies code
Please find below a revised and annotated version of your Post_to_Dbase
() routine. I corrected what seemed to me a couple of logic errors
(which I explained in my annotations):
Sub Post_to_Dbase()
'Suppressing screen updating and Excel alerts
With Application
.ScreenUpdating =
Hi
Sorry.. I am not able to help in this regard now because I don't have much
knowledge about that.
But what you have posted here is what I was searching on the net for so many
days but wasn't able to get.
Thank you so much. :)
I will now do some trial and error with your code.
I will post it
Here is what I am trying to accomplish along with the code I've
written thus far. I have input to website via xls, but am having a
tough time with the web extraction.
An Excel database 'sheet2' consisting of properties and property
contacts. Each row contains a property and related contacts.
1.
Dear Friends,
Is it possible to Put More than one Passward in a single work sheet
in Excel so that editability to the sheet would be restricted
to different user.
Kindly suggest.
Thanks and regards
Debashis .
--~--~-~--~~~---~--~~
Hi Anish,
if u don't have setup file then how u will recover passward. I think u have
another way. please share your this gr8 exprience as u know sometime there
are some emergency in which it won't possible to get help on time.
Naveen
98219 980081
On 10/21/09, Anish Shrivastava wrote:
>
> Hi A
Dear Friends,
Is i possible to Put More than one Passward in a single work sheet
in Excel so that editability to a sheet would be restricted to different
user.
Kindly suggest.
Thanks and regards
Debashis .
--~--~-~--~~~---~--~~
This is what I ended up with:
I assumed that the data was in sheet "Data"
The "other sheet" is called "Summary".
the macro looks like:
'---
Option Explicit
Sub Make_Summary()
Dim Dict_State, Cnt_All, R, ST, Skeys, I
'-
As with any question, there are as many
approaches to an answer as there are people
attempting an answer!
Have you done any VBA programming?
I threw together a macro to do this in about
10 minutes. Then it took another 20 minutes
to put together test data and add comments!
One method I prefer i
Thanks Dave,
At the moment, the sheet doesn't use a macro - it is done with a
formula that looks at and selects from a column within the work book.
S
On Oct 28, 3:55 am, Dave Bonallack wrote:
> Hi Simon,
>
> If you post your current code, someone can probably suggest the necessary
> mods.
>
>
Hi Experts,
I had a disappointing experience..
I have a workbook with a VBA project which I carry to my clients' place when
I go for audit and sometime run it on their machines.
Yesterday an antivirus program in client's computer deleted all the the VBA
code in my workbook calling it a "Macro Vi
Hi Simon
If you are already using excel to select random samples, I guess you are
familar with excel formulae.
VB is not required for this purpose. I have already uploaded a file here for
almost the same kind of problem. With smal modifications, the file I have
uploaded may serve your purpose.
V
Hello Excel Gurus, Im not sure why this macro works and sometimes not.
Could you please comment.
Sub Find_First_before_ Copy_Paste()
With Application
.ScreenUpdating = False
.DisplayAlerts = False
End With
Dim FindString As Integer
Dim Rng As Range
FindString = Shee
19 matches
Mail list logo
