Search:

Type: Posts; User: carmine; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Hi, Zeddy, If i want the declare the Sheet...

    Hi,

    Zeddy, If i want the declare the Sheet 'Particulars' data from the workbook.

    Secondly while copying from source file if the cell value is text (numeric formatted as text) it does not...
  2. Same error "Constant expression required." ...

    Same error "Constant expression required."

    Thanks
  3. Hi, Thanks Paul T, I get error on this line...

    Hi,

    Thanks Paul T,

    I get error on this line 'Dim aData(iLastRow, 1) '2d array' Constant expression required.

    Thanks.
  4. Hi,

    Hi,
  5. Hi,

    Hi,
  6. Macro to copy values from a closed workbook to the current workbook

    Hi,

    I'd like to copy values from a closed Excel workbook to the current one.
    The current workbook is named CNEE.xlsx, and has one worksheet named "CNO" where I'd like to copy the data to.

    The...
  7. Replies
    5
    Views
    1,883

    Hi, Thanks Zeddy. Thanks Maud. You both...

    Hi,

    Thanks Zeddy.

    Thanks Maud.

    You both ROCK the forum.

    Thanks.
  8. Replies
    5
    Views
    1,883

    Hi, Thanks RG, I have attached the sample file...

    Hi,

    Thanks RG, I have attached the sample file along with results, Please have a look.
  9. Replies
    5
    Views
    1,883

    Need to get results in message box

    Hi,

    This codes Displays Message Box from Row (B2) onwards in Sheet2 (named :Level2)


    Sub SumTotal()
    Dim Rng As Range
    Dim c As Range
    Worksheets("Level2").Select
    Set Rng =...
  10. Replies
    1
    Views
    181

    Change Cell Color

    Hello,

    Below codes works fine for me, In Column C if it has a value of '2' then set cell color to Red.



    Sub DeleteRows()

    Dim ChkRange As Range
    Set ChkRange = Range("C2:C200")
  11. Replies
    3
    Views
    366

    Hello, I have attached the sample text file...

    Hello,

    I have attached the sample text file and excel workbook.

    I will import single text file and Column B will be the name of sheet. The data to be sorted on column B and then transferred to...
  12. Replies
    3
    Views
    366

    Import 4 Text files to different sheet

    Hello,

    I have 4 text files in a folder & format, structure of files are same.
    I want to import all 4 files simultaneously to a workbook with each text file having their own sheets.
    Any one, a...
  13. Replies
    9
    Views
    882

    Hi, AWESOME kweaver & Maud. Thanks

    Hi,

    AWESOME kweaver & Maud.

    Thanks
  14. Replies
    9
    Views
    882

    Thanks kweaver. Exactly thats what i was...

    Thanks kweaver.

    Exactly thats what i was looking for.

    One thing if the number is increased in thousand than it does not give the output.
    Like starting 17500 Points 2000 How to do that.
    Can...
  15. Replies
    9
    Views
    882

    Hello, No, if its greater than 100 than...

    Hello,



    No, if its greater than 100 than split it into 100 each. if Col D points are 150 then split 100 & second one 50.


    In the same sheet in descending row order.

    Thanks in advance
  16. Replies
    9
    Views
    882

    Divide into Group

    Hello,

    I have points in Column D wherein if the value is greater than 100 then divide it into group.

    Col A---------- Col B---------- Col C---------- Col D----------Col E---------- Col F...
  17. Replies
    3
    Views
    1,865

    Hi, Thanks Paul T. Thanks R.G. Thanks a lot.

    Hi,

    Thanks Paul T.
    Thanks R.G. Thanks a lot.
  18. Replies
    3
    Views
    1,865

    Run script if start time in PowerShell

    Hello,

    I very new to powershell and i need help to achive this.

    At one stage of my poweshell script i want to define that if start time is 11:40 P.M. then hold this running script till 12:01...
  19. Replies
    14
    Views
    2,491

    Hi, Thank you, Paul Edstein for your help.

    Hi,

    Thank you, Paul Edstein for your help.
  20. Replies
    14
    Views
    2,491

    Hello, I have attached the sample file wherein...

    Hello,

    I have attached the sample file wherein i have mentioned the Employeed ID in the very first line,
    Once the letter is printed i will mark Employee ID on very first line.

    Thanks in...
  21. Replies
    14
    Views
    2,491

    Hello, Now onwards the document with a...

    Hello,



    Now onwards the document with a 'Employee Code' on the very first line of the document.
  22. Replies
    14
    Views
    2,491

    Hello Paul, Well, I agree with it and if i...

    Hello Paul,

    Well, I agree with it and if i flag Employee Code or ID on the very first line than that would be more sensible. What's your advise.
  23. Replies
    14
    Views
    2,491

    Hi, I have uploaded the sample file.

    Hi,

    I have uploaded the sample file.
  24. Replies
    14
    Views
    2,491

    Hello, Nicely written codes it works like a...

    Hello,
    Nicely written codes it works like a charm.
    I want to name the splitted pfd files from the word document which is located on the 6th line for the next 8 characters instead of ascending...
  25. Replies
    14
    Views
    2,491

    Save file as PDF files

    Hello,

    The below codes splits the files and creates a word document and its perfectly working to me desire, I want this files to be saved as pdf files instead of .doc file and want to add addin...
Results 1 to 25 of 31
Page 1 of 2 1 2