Quote:
Originally Posted by joeu2004[_2_]
"sumesh56" wrote:
sumesh56;1616779 Wrote:
as i told you earlier i am not an expert in using macro.
[....] i am asking silly (it may seem to others)Qtns.
Yes, I understand that you are new to VBA. Mistakes happen, even to
experienced VBA programmers. There are no dumb (silly) questions; only dumb
responses that call a question "silly".
That said, my only frustration is that you do not answer questions, and you
do not provide information requested. Something to keep in mind for the
future.
"sumesh56" wrote:
i have checked it in a few files and it works without any
problem.
Great! Good to hear.
"sumesh56" wrote:
[joeu2004 wrote:]
It is sufficient (and probably necessary) to have one copy
of the macro in a normal module.
================================
[sumesh56 wrote:]
what do you mean by normal module. do you mean that a module
which is saved as a .bas file somewhere outside he worksheet?
=================================================
No. If you look at the Project Explorer in VBA (press ctrl+R, if
necessary), you might see something like:
VBAProject (test seating plan...)
Microsoft Excel Objects
Sheet1 (Distribution...) <-- a sheet module
Sheet2 (Seating...)
ThisWorkbook
Modules
Module1 <-- normal module
You might not see a normal module until, in VBA, you click on Insert, then
Module.
In Excel, if you right-click on the worksheet tab, then click on View Code,
it takes you to the sheet module (e.g. object Sheet1).
I inferred that you had copied the macro code into a sheet module instead of
a normal module because you wrote previously: "i copy pasted your code to a
new sheet".
"sumesh56" wrote:
[joeu2004 wrote:]
I don't know why you were in break mode.
[....]
To avoid the problem, click on Run, then Reset before pasting
or importing the macro code into a workbook.
-===================================
[sumesh56 wrote:]
i need explanation to this how can i reset before pasting?
----------------------------------------------------------
As I said: in VBA, click on Run, then Reset.
"sumesh56" wrote:
[joeu2004 wrote:]
1. Column F of the Distribution worksheet is missing the
formulas of the form (F4 for example):
=IF(COUNT(D4,E4)=2,E4-D4+1,"")
[....]
===================================
[joeu2004 wrote:]
Please provide the file that does not work.
====================================
[sumesh56 wrote:]
I wish that never happen. hope that your macro is so strong.
I do not understand the English here.
My guess: "I wish that never happen" means "sorry about that omission; my
mistake; unintended"? Okay.
I do not understand "hope your macro is so strong" at all.
I had offered to modify the macro so that is creates the formula in column
F. Are you saying: "yes, please make that change"?
|
"That said, my only frustration is that you do not answer questions, and you
do not provide information requested. Something to keep in mind for the
future."
================================================== =====
"I inferred that you had copied the macro code into a sheet module instead of
a normal module because you wrote previously: "i copy pasted your code to a
new sheet".
================================================== =====
what you have inferred was correct. i used to manage with the sheet tab for inserting the code.
----------------------------------------------------------------------
"As I said: in VBA, click on Run, then Reset."
================================================== ======
i do not understand how to reset. when i clicked on the macros button in the code group i get run btn but not reset btn.there is nothing like reset in the options also.that is why i asked you again.
----------------------------------------------------------------------
""I wish that never happen. hope that your macro is so strong.""
================================================== ======
sorry for the poor english. what i intended was,since your macro seems perfect,there will be chance for me to quote a file in which your macro is not working properly.
------------------------------------------------------------------------
"1. Column F of the Distribution worksheet is missing the formulas of the
form (F4 for example):
=IF(COUNT(D4,E4)=2,E4-D4+1,"")
Consequently, the SUM formula in column G always returns zero.
Would you like me to add code to the macro so the formulas in column F are
created automatically?
kindly do that for me."
================================================== =======
here i requested you to kindly include the formula in the code.
----------------------------------------------------------------------
"i have checked it in a few files and it works without any
problem."
==================================================
with this comment i wanted to convey that after incorporating your directions as to edit the customize part, the code is working perfect.that is why i did not answer the qtns. sorry for that.
-----------------------------------------------------------------
1. Do you need to change seatingTitle, perhaps from "exam room" to just
"room"?
(Not necessary in the "test jasua 240314" file.)
2. Do you need to change distribWS and seatingWS?
================================================== ==
i do not want to change the exam room title to anything else.it is ok.
as you have suggested ,
yes it was necessary for the code to perform . so i changed the customize part as suggested.
----------------------------------------------------------------------
everytime i search for the necessary lines in the postings to quote the link with the excelbanter is going. so i am doing it in a text file and copy paste the comments. thats why i am not able to show the quoted part in my feedback.please suggest how can i insert quote tag wherever i want?
------------------------------------------
in your feedback some lines are in different color say green. how do you accomplish this?
================================================== ===
Now that a herculian task has been accomplished through creating makedistib macro i would like to request you to kindly create one more macro named createtemplate so that when i click on the seatingplan! and run the createtemplate macro i can get the distribution template. as you know there is no serious differences except the col headers. other columns are the same.