Ok, you should still take PHV's advice as it improves your macro, and you should definatly take SkipVought's advice, at least if you want to use SheetNM, put it as Cstr(SheetNM), but there is still a risk that SheetNM does not contain a valid Worksheet for your current workbook.
"Knowing that...
Well, there are quite a few dark corners of vba for me, I seriously thought x1down was not correct, and it had to be xldown ("L"), SkipVought am I missing something?
"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.
Good that it works, although I do not quite grasp what you are saying, wasn't x1 down what was written in the first place?
"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.
This works for me:
Sub CreateOutput()
Dim SheetName As String
SheetName = "test"
Dim RowCount As Integer
RowCount = ActiveSheet.Range("I1").Value
Dim RowCountAbs As Integer
Sheets(SheetName).Select
ActiveSheet.Range("A6").Select
ActiveSheet.Range(Selection, Selection.End(xlDown)).Select...
Thanks! Yeah Andy, I again am 100% behind what you are saying, the reserved names variable werent entered by me, but I should definatly correct those, and for the sticking to 1 way of naming variables, you are right, when you finish something friday, sometimes theres a few slipthrough.
Thanks a...
There is a common recognition here that goes up by a little purple star! Considering how giving people are around here, a few clicks for a purple star, and donations of 1/1000th of what the cost of the expertize would've been is a small thing to do.
"Knowing that you know is the greatest sign...
Yes HughLerwill, this is actualy the article that I started working upon, but I don't know if it is because I am trying to resist change, but I don't quite grap how I should start to apply it. They talk about conditional, "if VB7" which is probably what I should start using, but I don't know...
Besides the few "lazy" for's this code relies on alot of arrays,
I am having trouble understanding how multi-dimensional arrays would help my cause, of course it would limit the quantity of arrays, but every single operation on the string would still need ot be done exactly how it is done...
Alright skip, back to step one!
The logic is fairly simple.
We have a worksheet that currently has multiple lines, and each line is a grouping of multiple lines in another specific worksheet.
The grouping is always done in arithmetic fasion: (i.e., sum(), +, -(), +(), -sum(), etc...) Any type...
Here is the commented code (kindof? D:)
Function SplitMultiDelimsEX(Text As String, DelimStrings As String, _
DelimStringsSep As String) As String()
'''''''''''''''''''''''''''''''''''
' SplitMultiDelimsEX
' This function is like VBA's Split function or the SplitMultiDelims
' function, also...
You are 100% right! I got extremly lazy and wanted to comment the whole thing, but for the sake of the exercise I will comment this in english for the reader, I understand he can feel extremly dizzy from reading the whole code ><
"Knowing that you know is the greatest sign of stupidity, knowing...
Hey,
I don't want to take a whole lot of your time, I am simply looking for a good article on how to design or tweak a code for it to work on 64bits and 32 bits machines.
To put you guys into context I have designed about a year and a half ago a sort of database for timesheet / projects, in...
Hey,
I have recently designed a macro in order to split a cell arithmetic into mutltiple cells. This is a quite simple concept, but I found the time it took to design this, what I would think, "simply" macro, was quite arsh, I put around 5 hours on this, and I realize that my lack of experience...
Thanks for all your hints, Ill keep that in mind and try to get a project started. You might hear from me :)
Julien ~
"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.
! ? !
So any way, bug fixing is a mearly part time job I was doing to help my dad, since I programmed his database.
Im an accountant full time mind you!
Either way, The real project I did was a whole environment using excel / access with VBA in order to accumulate hours per project and...
Or you can definatly just have xlbo help you.
"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.
Hello Whitoja!
I can see you are new to this forum and I would suggest that you read the FAQ on how to post a complete question! This would help the greatly experienced programmers in here narrow down your problems and send you on the best path for a solution.
Its definatly worth it and its...
Hey, I am currently working as a bug fixer, and the lack of questions sometimes bore me out. So I figured I would try to add to my VBA knowledge.
The only place that I know off to learn about programming, and learn it well I might add, is to read on these forums. Could any one suggest some good...
Thanks for the tip! I will keep this in mind next time I have SQL in my VBA!
"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.