If you are going to put a checkbox in each cell in column B, then you would
be better off using data validation instead of the checkbox due to
performance issues. Below is the explanation of how to do this?
To put a dropdown list in cells, users can then select, in your case "Yes or
No" from a dro
Hi,Check the below link,
http://funwithexcel.blogspot.com/search/label/Delete
to learn about various types of deletes (deleting blank cells / rows /
columns, deletion based on a value etc.,)
On Thu, Jun 4, 2009 at 7:35 AM, Hemant wrote:
>
> Do it simply without using a macro:
>
> 1) Insert a ro
Hi Mike,Check the article below
http://funwithexcel.blogspot.com/2009/05/how-to-copy-multiple-workbooks-data.html
This helps in copying many small files into a single excel workbook and each
file gets it's own sheet.
On Mon, Jun 1, 2009 at 1:34 PM, mmccaws2 wrote:
>
> Hi
>
> Maybe I'm not using
I have done some experiments on this. Yes, you can do it by way of
sub-classing the MsgBox but that is really very cumbersome, instead try
creating a user form with the features whatever you want and use it as
MsgBox that is more easier than sub-classing.. (Link provided by bhaskar was
very helpful
hi, check the below article to do your job easily
http://funwithexcel.blogspot.com/2009/05/how-to-copy-multiple-workbooks-data.html
Hope this helps.
On Wed, May 20, 2009 at 12:02 AM, Atul Kesaria wrote:
> Is there any code where by all the files saved in a particular folder gets
> copied to a pre
Singh wrote:
> Hi,
>
>
>
> This code is not running. Does this requires any reference library to be
> included except default….
>
>
>
> Regards,
>
>
>
> Upendra Singh
>
> 9910227325
>
>
>
> *From:* excel-macros@googlegroups.com [ma
Hi, check the below link to write the excel sheet to Word. The code in the
article does not satisfy all your requirements, you might want to tweak the
code according to your requirements. Also to know the details of saving word
to PDF, you might want to check in some PDF forums too. They will have
hi, instead of writing macros in the excel file that your are sharing write
all the code in your own person xls. This will help you in preserving your
code and re using macros on any excel you have. Check the below microsoft
link to get more insight about Personal XLS.
http://office.microsoft.com/
Check the code block 4 in the below article to delete entire row based on a
blank cell in a particular column (for you it is first column)
http://funwithexcel.blogspot.com/2009/05/macros-to-delete-blank-or-empty-cells.html
On Wed, May 20, 2009 at 2:49 PM, tuigje7 wrote:
>
> How can I change the
Hi,
Check the link below for the VBA code.
http://funwithexcel.blogspot.com/2009/05/how-to-open-url-list-from-excel-using.html
Hope this helps.
On Wed, May 20, 2009 at 4:10 PM, Lexster wrote:
>
> Hi.
>
> I have a list of URL links in a 2003 spreadsheet, tab name="Sheet 1",
> first cell referen
I think that is definitely possible with VBA.. but to start with check the
below code to get google search result count in excel... you can explore
more and tweak the code accordingly to get your desired result.
http://funwithexcel.blogspot.com/2009/05/how-to-get-google-search-results-count.html
j
nfused for excel 2007.
> please let us know with full details As i could not found name->
> define in excel 2007.
> Please assist me .
>
> Regards,
> Abdul
>
>
>
> On May 25, 8:18 am, ddadmin2009 wrote:
> > Hi, There is a simple solution without creation
Hi, nice questions. I need to explore more to answer these questions but to
start with.. you got to know that OPEN statement supports below five modes.
Mode
*File** type*
Action
INPUT
Sequential
Read from
OUTPUT
Sequential
Write to
APPEND
Sequential
Append to
BINARY
Binary
Reading or
Hi Subu,
To make your work easy assign the macro you have recorded to a shortcut key
or a button. Check the article below to get familiar with those details
http://funwithexcel.blogspot.com/2009/05/macro-basics-assigning-macros-to.html
Just in case if you are not at all familiar with VB Editor and
Hi, There is a simple solution without creation of a UDF for this. This is
old traditional way of doing in excel. Check the article below..
http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas-in-excel.html
Hope this helps.
On Fri, May 22, 2009 at 5:20 PM, Aindril De wrote:
> De
Hi,The below article should get you started
http://funwithexcel.blogspot.com/2009/04/macro-for-conditional-formatting-in.html
I have shown clearly how numbers / strings / conditions handled (colored)
using macros. Tweak the code according to your requirements. As far as I
remember color index of Re
Sorry forgot to mention once your conditions are met.. use
Activesheet.Tab.ColorIndex
= 4 (or) Activesheet.Tab.ColorIndex = 2 accordingly. Article shows how to
color the cells not the tabs.
On Fri, May 22, 2009 at 4:42 PM, Aindril De wrote:
> Hi Can you send a sample sheet please
>
> Regards,
>
check the article below, this should give you a start for what your are
looking to do
http://funwithexcel.blogspot.com/2009/05/macro-to-copy-worksheets-from-master.html
In this I have shown how to copy the whole excel sheet, you got to tweak a
bit, get the active cell and paste all sheets one by
There are several ways of doing this, "using a macro in different sheets" -
u can assign macro to a shortcut, add as a button to the toolbar etc., Check
the below article, it will explain you how to assign macros to shortcut
keys, buttons and objects.
http://funwithexcel.blogspot.com/2009/05/macro-
This example sorts the range A1:C20 on Sheet1, using cell A1 as the first
sort key and cell B1 as the second sort key. The sort is done in ascending
order by row, and there are no headers. This example assumes there is data
in the range A1:C20.
Sub SortRange1() Worksheets("Sheet1").Range("A1:C20
the FILE, I cancel the default "save" operation and issue commands
> to update the Oracle database.
>
> There's LOTS of perfectly valid reasons to recommend using the Save event.
> It's all part of the Design process...
>
> Paul
>
>
>
http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas-in-excel.html
check the article above for color conditional formatting with an example
(steps 3 and 4). Tell me your specific case so that I can tell you what to
keep in the formula or cell value.
On 4/15/09, Suryaprasad.bv w
Here is a very easy method to resolve this issue rather than using the VBA
code.
http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas-in-excel.html
Hope this helps.
On 4/13/09, Dave Bonallack wrote:
>
> Hi,
> A quick way to reveal which cells have formulas:
> Ctrl+`
> That's Ctr
Hi Hamster,
I don't know your requirement. But with design perspective writing a code
around save is not recommended because you might hit save button or Ctrl + S
many a times unknowingly while working with excel. Just check it out.
have fun,
ddadmin.
On Mon, Apr 13, 2009 at 10:11 AM, Hamster wro
Hi Ayush,
I like the tool but how different is this from copy / paste. I really don't
see any difference. Can you explain some real time scenarios where this is
used more than copy / paste.
Thanks,
Srinivas.
On 4/13/09, Ayush wrote:
>
>
> Dear Members,
>
> A new tip of excel has been published o
check the below link
http://funwithexcel.blogspot.com/2009/04/macro-to-write-mathematical-palindromes.html
You might tweak or extend from there.
On 4/14/09, Luciano Paulino da Silva wrote:
>
>
> Correction:
> QGAGGAAGGAGQ
> Palindromes Number Repeats Number
> QGAGGAAGGAGQ
As shown in the below article...
http://funwithexcel.blogspot.com/2009/04/sorting-of-dates-with-different-formats.html
use the 'data' tab to split the name and Id. Hope this helps.
On Mon, Apr 13, 2009 at 7:12 AM, Harmeet Singh wrote:
> attached file has the solution
> assuming that ID will be of
27 matches
Mail list logo
