Yes rightly said. The file which has been downloaded from software isn't
having proper systems date format. So I would like to make it in
DD.MM. (2.2.4 digits)
Kindly do the needful.
On Mon, Jun 16, 2014 at 5:19 PM, Paul Schreiner
wrote:
> Guys:
>
> I started with the same response, until
OK, the syntax:
if Range("rangename2").Value = 16
fixed everything. Thank you very much Paul.
Dean
On Monday, June 16, 2014 11:43:06 AM UTC-7, dea...@aol.com wrote:
>
> I've been gone for a long while and forgot some of what little I knew
> about proper VBA syntax. This is an easy one, I'm s
I'm not sure what you are asking about the range names. I assigned each to
a group of cells in a row, cells that detect if the column is empty or not.
The macro, which hides columns that are empty, works fine as long as the
value is not 16. In that case, no columns are empty and the formula y
HI
Since date format is not the same excel can search directly what you want,
however macro in attached sheet can help you to fetch data one by one. You
need to keep open sheet 1 & sheet 2 (Only 2 sheets). Goto sheet 2 workbook,
hit that blue button & select the date which is in sheet one in colum
Wait... just be clear...
Are you using RangeName1 as a variable that contains the name of a Named Range?
or is "RangeName1" the name of a range?
also, I can see why it might have a problem with:
Selection.SpecialCells(xlCellTypeFormulas, 16).Select
since I have no idea what that line is sup
Thanks Paul, but I tried this, I think, before posting. Even though
rangename2 is 16, it is getting hung up on one of the steps that I expect
it to take only if it is less than 16. Perhaps I need to declare that the
rangenames are integers within the VBA macro, or something like that - do
you
What you're describing is reminscent of some old Fortran style IF statments.
In VBA you CAN use goto's, but it's not really all that common.
In fact, I think they're only keeping them around for backward compatibility.
I THINK the equivalent to what you've described is:
If RangeName1 < 16 the
I've been gone for a long while and forgot some of what little I knew about
proper VBA syntax. This is an easy one, I'm sure, so would someone kindly
help me with the proper syntax on the if and goto statements? I'm getting
things about end ifs without block ifs, etc. Thanks much, Dean. I wa
Please respond to gurjant.si...@damcosoft.com
*Position: QA ManagerLocation: Charlotte,NCDuration: 6+ Months*
JD:
We are looking for a resource who has worked in a team to setup best
practices for testing in .Net/AngularJS/Tibco/PL SQL.
Thanks and Regards,
Gurjant Singh - (Gary)
Technic
Hi vaibhav,
Fist upon thanks for the reply. I will prefer both the way
It would be very helpful If u help me on the same.
Regards
On 6/16/14, Vaibhav Joshi wrote:
> Hey
>
> How do you want to fetch? Formula or Macro?
>
>
>
>
> On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta wrote:
>
>> Hi Team,
>
Guys:
I started with the same response, until I noticed that
I believe what he's saying is that the value in the cell is NOT an Excel date:
He said: "Now it is not in system's date format"
so, he cannot change the display format to display it in another date format.
the solution using the
Hey
How do you want to fetch? Formula or Macro?
On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta wrote:
> Hi Team,
>
> I want to fetch data from one sheet to another sheet by referring the
> data, Attached sheet will explain you what i want exactly.
>
> Request all of you to kindly help me on th
Hi Team,
Your valuable replay on this will be appreciated.
Regards
On 6/15/14, Jocky Beta wrote:
> Hi Team,
>
> I want to fetch data from one sheet to another sheet by referring the data,
> Attached sheet will explain you what i want exactly.
>
> Request all of you to kindly help me on this
>
>
Sham, I tried the steps below and tried to open the workbook in Excel and
got the dialog box that states "Excel found unreadable content in FILE
NAME.xlsm". Do you want to recover the contents of this workbook? If you
trust the source of this workbook, click Yes". After clicking Yes, it shows
t
14 matches
Mail list logo
