Our site website links ; https://marijuannashop.com/
https://marijuannashop.com/product-category/cbd/
https://marijuannashop.com/product-category/indica/
https://marijuannashop.com/product-category/hybrid/
https://marijuannashop.com/product-category/hash/
https://marijuan
Our site website links ; https://marijuannashop.com/
https://marijuannashop.com/product-category/cbd/
https://marijuannashop.com/product-category/indica/
https://marijuannashop.com/product-category/hybrid/
https://marijuannashop.com/product-category/hash/
https://marijuan
*Thank you!You, sir, saved my day (interview tomorrow ;D)*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate t
Is there a way to specify the column width so the email appears more like a
table?
On Wednesday, December 26, 2012 at 11:00:57 PM UTC-5, Anoop K Sharma wrote:
>
> Hi Subu,
>
> In attached file you can see another sheet added with images describing
> the solution to your problem.
> Open this work
Hi all,
I have a macro that I want to run every time I print. This is referencing
Sheet 4, finding the latest date in the column, and putting that date into
the header (Figure 1 below).
I've been able to successfully get the AddHeader() macro to run manually,
but it will not run when I print S
Folks,
I know I have seen this question here before but I can't find it anywhere
and regret that I have to create a second post re/ this. My sincerest
apologies. Please feel free to redirect my thread.
However, I'm looking for the keyboard shortcut to open the menu that shows
when you right-cl
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” -
Hi,
I have a rather strange problem: I have a master file with INDIRECT
worksheet functions to three different files, alpha, beta and gamma (for
simplicity's sake, the actual project has about 100 files). Without opening
these three files, the cells with the INDIRECT calls in the master workbo
You're the best! Thank you so much!
Chris
On Thursday, June 5, 2014 2:29:20 PM UTC-4, Vabz wrote:
> also check this:
>
>
> http://www.excelforum.com/excel-programming-vba-macros/652705-import-specific-line-from-multiple-text-files.html
>
> Cheers!!
>
>
>
e it has to cycle through the
first 4,000,000 rows. Hence, I said that it's not clean code. Is there any
way where I can specify the starting row easily?
Thanks so much for your help in advance.
Chris
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:I
hhajer.
> Sent on my BlackBerry® from Vodafone
> --
> *From: * Chris >
> *Sender: * excel-...@googlegroups.com
> *Date: *Tue, 25 Jun 2013 10:53:28 -0700 (PDT)
> *To: *>
> *ReplyTo: * excel-...@googlegroups.com
> *Subject: *$$Excel-Macros$$ Duple
I've found a ton of info online but unfortunately, nothing that solved my
problem: Every month, I prepare a workbook which is assembled from 5
different workbooks. I move some sheets from each of these five into a
consolidated workbook. The only way I can get it to print double-sided is
to se
aste Links" but that didn't work because it
just created a link to the cell where copied from. Not what I'm looking
for.
I believe I asked something similar but searched this form and couldn't
find anything. My apologies if this was asked before.
Thanks,
Chris
--
Are y
Happy Friday Everybody,
hope it is allowed to throw in a question here regarding a certain behavior
in Excel that I've just never seen fixed/improved. Ayush, maybe you or
anybody else here know. Just some trivia I'd like to understand as a geek.
I can't even remember what the first version of
; you can try pivot charts . Find the sample file attached. Just select the
>> day in the report filter
>>
>>
>>
>> On Thu, Apr 4, 2013 at 10:03 PM, Chris
>> > wrote:
>>
>>> I have data by day for an entire year. A date in column A, the weekday
I have data by day for an entire year. A date in column A, the weekday
(Mon, Tue, Wed, etc.) in column B and a value in column C.
Somewhere else on the spreadsheet, let's say D1, I enter the weekday into
the cell. I would the like a chart to ONLY use the rows in the entire
table that have that
gt;
>
> then copy and paste special col b data
>
> Regards
> Ashish
>
>
>
>
>
>
>
> On Wed, Apr 3, 2013 at 7:16 PM, Chris >wrote:
>
>>
>> Morning!
>>
>> I'm often faced with the following problem (simplified here): I have data
Morning!
I'm often faced with the following problem (simplified here): I have data
in the following cells of a spreadsheet:
A1, B2, A3, B4, A5, B6
and would like to copy column A a paste it into B so that there are no
gaps, basically turning the two colums showing zigzag data into one. Of
ber-alphanumeric-text-186/
>
> Regards,
> Sam Mathai Chacko
>
>
>
>
Thank you so much! Very much appreciate this link. It certainly helped!
Christoph
>
>
On Wed, Mar 20, 2013 at 8:15 PM, Chris >wrote:
>
>> Hi Everybody,
>>
>> I thought
Hi Everybody,
I thought I had somewhat advanced Excel skills but then the following made
me feel like I'm back in the beginners' group: Usually people ask here how
to achieve something in Excel or VBA. I actually have the answer but I
would like to understand it. This morning, I needed a quick
hi,all,so wat kind of skill can call Senior UI.
On Fri, Feb 22, 2013 at 12:15 AM, RAJESH ALPHASYNOPSIS <
rajesh.alphasynop...@gmail.com> wrote:
> Title:UI Developer.
>
> Location:Englewood, CO
>
> Duration:12m+
>
> 2 positions.
> Client Need Senior UI ( User Interface Developer) Consultant, Mus
Thank you very much, everybody! The macro works, I had a similar one. I was
hoping I could live without a macro but it's not the end of the world that
this task requires one.
Again, appreciate everybody's feedback!
Chris
On Thursday, January 24, 2013 2:26:26 PM UTC-5, Chris wro
es this kinda of sorting/changing
quickly?
Thanks,
Chris
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Ad
Hi there, Experts,
I use the "FREQUENCY" command a lot to group data into buckets via an
array. It works great. I was wondering if there is a reverse function for
this. In other words a lookup that allows to use buckets.
Say in column A1 I have the minimum value of a bucket, in this example
IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Chris
> *Sent:* 17 September 2012 8:28
> *To:* excel-...@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Spreadsheet within Spreadsheet
>
>
>
> Thanik
e
>
>
>
> The code is actually filtering data from sheet2 and pasting it in Child
> Spreadsheet.**
>
> * *
>
> *Enjoy **J***
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-...
e other objects I could possibly use for
this idea? Maybe somebody has a sample to share?
Thanks for your help in advance,
Chris
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate
These Youtube Videos my might Help
http://youtu.be/nZfySb0FI8w - A VBA Formula Trick
http://youtu.be/W82P4cxVK3M - Application.WorksheetFunction
On Monday, May 14, 2012 4:23:28 AM UTC-6, Bullet wrote:
>
>
> Hi All,
>
> Can anyone explain how to use Vlookup, Index, Match, Offset function in
>
& STG 03840 20.01 INTERSTATE MOVING & STG 03840 38 COLT EXPRESS LLC
06040 38.01 COLT EXPRESS LLC 06040 60
Chris
http://www.everydayVBA.com
On Wednesday, May 9, 2012 9:01:41 PM UTC-6, lee wrote:
>
> *col i in Sheet 2 needs to be filled up . Can u please fill it up with
>
hange
sheet within my macro's workbook. However, it does not get executed when the
user changes sheet within his workbook.
What am I missing? Is there any documentation on this that you can point me to
please?
Ch
whole contents so
the user can provide completely new input easily.
Chris Boxall
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
font size of the date to font size
10? If I use a different line of code to change the font size it is
reformatting the date back to mm/dd/.
Thanks!
Chris
--
--
Some important links for excel users:
1. Follow us
(or at least better English for non-native English
speakers) will always encourage more respect.
Chris Boxall
*General suggestions:*
1. Don't put your email address in a post unless you're dying for more
spam in your inbox.
2. Don't eve
does not seem to provide such a utility. Can you tell me if such
utilities are available and how I could obtain them?
Chris Boxall
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
-NAME are not in the list. How can I see what other environment variables
are available?
Chris
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Daniel
Sent: Wednesday, December 15, 2010 3:57 PM
To: excel-macros@googlegroups.com
Su
Hi,
I would like to know if this is possible in excel 2007 and any
pointers where to look.
- I have a block of cells (like a sort of table) which I want to
define as one object (is there any way I can do this)
- Is it possible somehow with a single function to copy this object
(or block of cells
n the Immediate Window by typing:
Test Range("A1")
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tuto
ot;A1", "L1"), "Jan")
End Sub
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Vid
be caused by the presence of another
array function within the bounds of the selection"
Exit Sub
Exit Sub
End Sub
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
ur function when the drop-down updates.
Try Googling for Excel calculation tree to see how Excel goes about
figuring out what to calculate and when.
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
-
hough
you're normally better to put something in the loop's test to allow
you to break out. It's normally a little easier to understand.
Regards,
Chris Spice
ggest using the 'Change' event on
the worksheet object. I can provide further guidance on this if you
like.
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
this could be quite an involved process!
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and
Hi LD,
Nothing springs to mind. Could you also post the
'SetPasteRangeByColumn' function, plus a sheet containing examples of
the data you're working with?
Regards,
Chris Spicer
www
nformation on licences and credits in place.
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Te
dd-in called TechnicanaUtilities and will
upload this to the files section of this site. If you load the add-
in, it will automatically run the code each time you press CTRL+SHIFT
+A together.
Regards,
Chris Spicer
www.Technicana.com
' Distributed under the Creative Commons licen
Hi All,
I recently had to give some guidance to some other developers
regarding error handling in VBA. I have put this guidance into a
short video which I thought might be helpful to developers on this
group.
http://technicana.com/vbaSection/Videos/ErrorHandling.html
Regards,
Chris Spicer
This would confirm whether the event is being
fired or not.
I know a little bit about C++ add-in development, but this is probably
not the best forum for those questions. You can forward the question
on to me directly or there may be an XLL forum on Google Groups.
Regards,
Chris Spicer
www.Technica
Hi Satish,
I had the chance to look at this further this morning. The following
code seems to do the trick of pasting one workbook's data under
another.
All the best,
Chris
www.Technicana.com
Sub CombineFiles()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
vM
e following:
Range("A1:Z92").Copy
As a quick fix, replace your line of code with the following:
Range("A1:Z" & Cells(Rows.Count, "B").End(xlUp).Row).Copy
A more elegant option might be to use 'Sheet.
aste Range("AA" & vStart & ":" & "AA" & Cells(Rows.Count,
"A").End(xlUp).Row)
Let us know if you have a breakthrough or can provide an example sheet
for us to test with.
Regards,
Chris Spicer
http://technicana.com/EasyDeeby.html
--~--~--
ut for is a dangling reference to the xla
addin... you should be able to remove that reference programmatically
when it comes time to distribute your workbook.
I hope this helps,
Chris Spicer
www.Technicana.com
On Jun 4, 8:08 pm, mikeallen7 wrote:
> I have 2 vba modules that are both within
I suppose you could add code to module 1 to unprotect the project it's
in, then reprotect itself once you've removed module 2. Would this be
suitable for your needs?
On Jun 4, 8:08 pm, mikeallen7 wrote:
> I have 2 vba modules that are both within a protected project. I wish
> to remove one mo
Rick,
You weren't far off - you just need to add an iif statement to your
concatenation (see below).
Regards,
Chris Spicer
www.Technicana.com
P.S. With regards the line that reads vSQL = vCell, are you sure this
is what you're trying to achieve? It seems to be that a blank cell in
as this doesn't seem to occur in Excel 2007
(which I now use), but I'm pretty sure it occurred in Excel 2003.
Regards,
Chris
On Feb 26, 7:36 am, Lavprasad Kori wrote:
> Hi Rajesh,
>
> For the Calcuation Setting you have to go to *Tools - Options - Calculation*
> **
> I
You're very welcome.
On Feb 23, 3:36 pm, Art wrote:
> Chris,
>
> Thanks a lot. I would've spent weeks (not to say months) to figure
> this out.
>
> Tks again,
> Art.
>
> On Feb 21, 12:11 pm, Chris Spicer wrote:
>
>
>
> > Hi Art,
>
> &g
; wksPerformance.Range
("B2").Value
wksInitial.Visible = True
wksInitial.Name = "InitialCostAlt" & wksInitial.Range
("H3").Value
Next i
I think it will do what you're looking for.
Regards,
Chris Spicer
Starting up at www.Technicana.com !
= "M"
MonthCodes(7) = "N"
MonthCodes(8) = "Q"
MonthCodes(9) = "U"
MonthCodes(10) = "V"
MonthCodes(11) = "X"
MonthCodes(12) = "Z"
End Sub
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~
I need to count data based on 3 criteria.. I have this working for 2
but now need a third..
ColA is just an identifier, ColB is the date some work was done, ColC
is if it was completed.
The results section is the count area. ColAA is the month/year to
check, ColBB is the count of how many dates f
59 matches
Mail list logo