Wow, thanks for the responses. I'll check them all out and see what works best for me.
Baldy McFatfat
"If at first you don't succeed, skydiving is not for you.
My company is wanting me to learn SQL language. I have a very minimal (and probably incorrect) knowledge of even basic programming; I have tinkered with VBA for excel and that is about it. What I have learned of VBA, I learned on my own while flipping through a 'For Dummies' book and...
I have heard it said several times and places not to use ACTIVE____ at all. Is there a specific reason for this? I have had to self teach myself what I can about VBA and programmin in general, and therefore I am still ignorant in a lot of the nuances of it.
Baldy McFatfat
"If at first you...
The basic purpose of this whole thing is to sort through data based on one column's data and move things around within the report. I was basically seeking to find out if it was possible to have a statement like ("A1:A14") have a variable in it.
For Count = 1 to X is just telling the macro to...
I will go ahead and insert the entire code up to the point of where I need help. And once again, I do apologize for my faults in this area. I am basically looking for it to select a range that goes down a certain number of rows from wherever it happens to be at that point in the macro (if that...
Will I have to make the input box for the range seperate from other items at that point? I ask this cause the existing input box provides the variable for other functions within the code. I mainly want to know if I need to insert another input box into my macro.
Baldy McFatfat
"If at first you...
I have an issue where I need a range to have a variable figure in one of the positions. This variable is set when running the macro by an input box. I am trying to learn all this VBA stuff with no actual programming background and I have been able to do most of it with the help of websites such...
I'm interested in what else will come up, because that might be able to help me in a couple reports I run for work. If anyone else has any suggestions, please provide.
Baldy McFatfat
"If at first you don't succeed, skydiving is not for you.
Maisie,
In regards to your question of how do you get notified that there is activity in your post, you can select to get an email notification whenever that particular thread recieves a post. you can select it right below where you type in the response.
Regards,
Baldy McFatfat
"If at first...
You can do it either way. I'm just saying you don't need VBA. However, if you are more familiar with it, you could use some Do Loops with the LookUp included in the coding as a worksheet function. I was just saying it would probably easier to do the formula. Definitely less time consuming to set...
I have outlook on my main desk top but can't access it from some of the other computers I may have to work from. The alram using Excel works great for me causing I just have it on a thumb drive that can plug into any computer and access. Thank you to both of you.
Baldy McFatfat
"If at first...
As long as you are moving data cell-forcell (meaning not trying to merge two cells into one) then you will be fine. the LookUp functions are extremely useful when it comes to grabbing data from one workbook to another. At work, I use the function to pull info from four pages all in different...
I thin he is saying you don't need code but can do it manually just as quick. Unless you have several hundred lines you would need to delete all at once, I believe manually is just as efficient.
Baldy McFatfat
"If at first you don't succeed, skydiving is not for you.
This actually doesn't need VBA at all. If I am understanding this correctly, you are trying to pull data from a complete seperate workbook. If that is so, you would just need to use a LookUp formula and specify the location of the worksheet you are attempting to access. I don't want to give...
Not sure if this would help any, but do the other computers have their macro security set to medium or low?
Baldy McFatfat
"If at first you don't succeed, skydiving is not for you.
The document being protected will stop you from doing any changes, even correct spelling. All you would need to do is unprotect it then spell check away. Had the same issue a little while ago. Hope this helps.
"If at first you don't succeed, skydiving is not for you.
xlhelp,
This was extremely useful, thank you. Only one question. I'm the type of person that is usually looking through eighty things at once and sometimes get a little over excited when closing certain windows that I'll accidently close something I meant to stay open. With that in mind, is...
Thank you all for the information. Thank you mintjulep for that advise. As skipvought stated earlier it was an equation question but I didn't know. So thank you to all. And please forgive my ignorance.
I know this is a worksheet function and thoroughly know how to use it within a worksheet itself. I was wondering if there is a way to utilize this function in vba code to input a phrase where two sections of the code are from a seperate workbook altogether. I am looking to utilize vba to create...
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.