Replace the following line in your code
Worksheets("Input").Range("source_col:source_col").Copy _
Destination:=Worksheets("Output").Range("dest_col" & 1)
with
Worksheets("Input").Range(source_col & ":" & source_col).Copy _
Destination:=Worksheets("Output").Range(dest_col & 1)
Akhilesh Kumar Ka
The following code worked for me. You may give it a try.
Before running the following code write something on each of the three
sheets.
You can just copy and paste the following code and run. Hope it helps.
'==START
Sub createPrintJobs()
Dim i As Integer
Dim batPRN As String
ba
Hi All,
Folks thanks for the wonderfull support for getting out with good postings
and tips hope all will continue in the same fashion and keep this
environment alive.
*Question:* *If you have comments in a scrumbled all over the spread sheet (
Not in order) but you want to delete the comments
Name: Aindril De
Subject: Useful Shortcut keys Using Ctrl and Shift
Tips:
Ctrl+Shift+4 (i.e. Ctrl+$): Formats your current selection as currency
Ctrl+Shift+5 (i.e. Ctrl+%): Formats your current selection as a percentage
Ctrl+Shift+6 (i.e. Ctrl+^): Formats your current selection as scientific
nota
Name: Aindril De
Subject: Shortcut keys for selecting cells, rows, and columns in Excel 2003
Tips:
1. Extend the selection in the direction of the arrow key
[Shift]+[→], [Shift]+[←], [Shift]+[↓], [Shift]+[↑]
2. Select the current column
[Ctrl]+[Spacebar]
3. Select the current row
[Shift]+[Spaceb
Hello Group,
The code at the end of this post does not work, but I made it to be
the best approximation of what I need. How it *should* work:
The following is a map with header columns:
G H I J
s ID ClientIdq
col G holds the ORIGINAL column reference l
I was not able to get this to work. I have heard that PDF creator has
hooks in it for this kind of thing, but I have not investigated that
yet.
On May 21, 11:05 am, Dustin wrote:
> I'll try that out and get back to you.
>
> For this example, creating multiple print jobs is trivial - but the
> ac
name: harsh shah
subject : formula reference
tip : press ctrl + [ (will show from where the formula has been derived)
& ctrl + ] (will show where this cell has been used in formula)
On 10/06/2009, Rakesh Sharma wrote:
>
>
> HI All,
>
>
> Name : Rakesh Shar,ma
> Subject : Show formulas in
Hi,
Keep the range fixed, countif($a$2:$a$10,"M") should work with M or F.
Sri
On Sun, Jun 7, 2009 at 5:24 PM, Ramesh Katta wrote:
> Dear Members,
>
> My question seems to be very simple, please don't laugh at me.
>
> I have 2 columns that are A1 contains Names and B1 contains Sex of
> employe
It works for the entire work sheet
SRI
On Mon, Jun 8, 2009 at 3:31 PM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:
> Hi Ramesh,
>
> Thanks for the tip but its showing the formule of current cell only not for
> entire work sheet.
> Is there any another way to use this tip Kindly sha
Hi Satish,
It's difficult to say without an example of what you're trying to copy/
paste, but I will try to help as best I can.
1) You might like to place a break point immediately after this line:
Range("A1:Z" & Cells(Rows.Count, "A").End(xlUp).Row).Copy
Immediately after this line of code ha
HI All,
Name : Rakesh Shar,ma
Subject : Show formulas in printable format
Tip : Press Ctrl + ~ ( To View formulas in printable format or
to take a printout for forumlas enter in cells)
On Jun 5, 8:41 pm, Ayush wrote:
> Hello Everyone,
>
> Please submit your tip in this post for Week
HOW TO VBA MICROS USE.
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.co
I already tried that but it does not work. Does someone have another
suggestion ?
I know you can do it as I have already seen it.
On Jun 8, 6:20 pm, zheng yu wrote:
> You can simply use "record macro" and do all the process through,then you
> get it in VBA. You can see the VBA code in VBE edito
Hi Harmeet,
Kindly brief us about this software like what it works and how its
works,,
*
BR
MSN*
On Wed, Jun 10, 2009 at 3:35 AM, Harmeet Singh wrote:
> Hi Friends,
>
> I have a gift for all the users who are helping new users to excel
> themselves in excel.
>
> It doesn't mean
Hi Group...
I am trying to copy data from 100 *similar *excel files and copying in one
excel sheet. I tried below mentioned macro, but one problem has raised. In
each excel file there are about 98 rows but in the merged file only first 92
rows are copied and pasted. Can anyone find out the mistake
*Type phone number without any space, bracket, etc. then change the format
of the cells. Rigt Click>Format Cells>Number Tab>Select Special in Cetegory>
Choose English (U.S.) in Language>Choose Phone Number in Type> Click Ok.*
On Tue, Jun 9, 2009 at 5:08 PM, amrahs k wrote:
> Dear Harmeet an
17 matches
Mail list logo
