-
-
-
-
-
Well I TRY to keep myself from being sloppy… not that it always works…
Thanks for the articles Steve! -
Well I TRY to keep myself from being sloppy… not that it always works…
Thanks for the articles Steve! -
Thanks Hans… This is a great reference for me as I get used to it…
-
Thanks Hans… This is a great reference for me as I get used to it…
-
Nope… Not the same one… Different project… (I’m not having a good week!!
)This is the workbook with 20 odd sheets and 1800 named ranges that I asked about before…
Remember I posted wanting to know if it was possible to use the Subtotal levels in code… I was supposed to post back with an example but didn’t get a chance to… I decided it was easier to just look at the sheets as a whole and find the Total lines that I needed…I am pulling in the Currency from the line above each department total…
tieinSheet.Cells(rwNew, 1) = mySheet.Cells(rw – 1, 1) ‘gets currency from line above totalI’ll attach a sample workbook so that you can see what I am doing… It’s got dummy data and there are no company names or anything, so it will be okay…
I deleted all the sheets and code that weren’t relevant…. Hopefully you’ll be able to see right away what I’m trying to do… The “TieIn” sheet is what we’re talking about right now…Thanks Hans!
-
Nope… Not the same one… Different project… (I’m not having a good week!!
)This is the workbook with 20 odd sheets and 1800 named ranges that I asked about before…
Remember I posted wanting to know if it was possible to use the Subtotal levels in code… I was supposed to post back with an example but didn’t get a chance to… I decided it was easier to just look at the sheets as a whole and find the Total lines that I needed…I am pulling in the Currency from the line above each department total…
tieinSheet.Cells(rwNew, 1) = mySheet.Cells(rw – 1, 1) ‘gets currency from line above totalI’ll attach a sample workbook so that you can see what I am doing… It’s got dummy data and there are no company names or anything, so it will be okay…
I deleted all the sheets and code that weren’t relevant…. Hopefully you’ll be able to see right away what I’m trying to do… The “TieIn” sheet is what we’re talking about right now…Thanks Hans!
-
Hmmm… Well thanks anyway Steve…
I personally use…
bln for Boolean
int for Integer
lng for Long
sng for Single
dbl for Double
etc…
I think that’s pretty standard…I guess it doesn’t really matter as long as the prefixes are intuitive and consistent… I was just curious because I’m trying to get better at Excel VBA, I don’t have a book (yet), Excel 2000 Help SUCKS (half the time it doesn’t even show the declarations in the examples…), and I know there are experts on here whose opinions I trust and respect… Every time I declare a worksheet or a range or whatever, I think… “Now what should I be using here… sht for Worksheet… wrksht…. or what??” … I’m just particular (or should I say peculiar) like that…
-
Hmmm… Well thanks anyway Steve…
I personally use…
bln for Boolean
int for Integer
lng for Long
sng for Single
dbl for Double
etc…
I think that’s pretty standard…I guess it doesn’t really matter as long as the prefixes are intuitive and consistent… I was just curious because I’m trying to get better at Excel VBA, I don’t have a book (yet), Excel 2000 Help SUCKS (half the time it doesn’t even show the declarations in the examples…), and I know there are experts on here whose opinions I trust and respect… Every time I declare a worksheet or a range or whatever, I think… “Now what should I be using here… sht for Worksheet… wrksht…. or what??” … I’m just particular (or should I say peculiar) like that…
-
Thanks a million Hans! …I thought of Match and Offset, but I wasn’t sure…
Your code works great… except that I forgot to deal with the changes in currency (column 1 on “ByDeptandProd” sheet)… so it finds the Canadian amounts when it has switched to USD… Oops… How would I do this with two conditions to match? For example… C$ 001 Total is different to U$ 001 Total…
BTW… You’re the best!
-
Thanks a million Hans! …I thought of Match and Offset, but I wasn’t sure…
Your code works great… except that I forgot to deal with the changes in currency (column 1 on “ByDeptandProd” sheet)… so it finds the Canadian amounts when it has switched to USD… Oops… How would I do this with two conditions to match? For example… C$ 001 Total is different to U$ 001 Total…
BTW… You’re the best!
-
Thanks!… I can wait… (I’ve been wondering this for agessssss…)
Author
