Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    158

    Re: how to link datas from excel to word

    guys ... i got it, its paste special-unformatted text.

    thanks a lot anyway
  2. Replies
    2
    Views
    158

    how to link datas from excel to word

    Hello all,
    im trying to link datas from excel to a word (containing code, which will be feed in to a different program)
    but when i paste it as link(paste special), i whole paragraph alignment goes...
  3. paste the minimum value of a range at A1

    i want paste the minimum value from q5:q36 in A1 (i making some silly mistake)cant not able to figure out
    thanks a lot for your cooperation
  4. Re: insert a sheet and rename it as that of the variable

    thanks Mr Andrew , But is there any way to do it without the sheet count, because im planning to use it multiple time (im new to VBA, so not good with loops ). every time the sheet count will change.
  5. Re: insert a sheet and rename it as that of the variable

    Michael,
    Thank you very much, but If i run this, only the first row is getting copied, there are other rows with the same value
    hope you understand me now
  6. insert a sheet and rename it as that of the variable

    i am copy pasting a table , with a variable , i want rename the new worksheet in the name of the variable

    for example


    Sub Tp6s()


    Sheets("Sheet1").Select
    Dim i As Range
  7. Replies
    1
    Views
    309

    VBA to check the highlighted row

    i would like to know how to copy a value from a row, if any of the cell in that row is highlighted( used conditional formatting, light red fill with dark red text )

    for example. i want check the...
  8. copy and paste the value of a cell if any cell in a row is highlighted

    hello,
    i need to copy the value of a cell in ( say column B ) to column X if any of the cell is highlighted in row 1,
    like wise i need to move on to the next row until the empty row
    please let me...
  9. VBA to delete a row containing a value equal to the value corresponding to the highlighted cell

    Few rows of the tables will be already highlighted, i want to delete the rows with value(at column A) equal to the value of column a of the highlighted ones

    for example

    <tbody>
    1.50
    270.00...
  10. Replies
    2
    Views
    245

    Re: problem with my macro, please help

    yes... i understand ...thank you very much:stickouttounge:
  11. Replies
    2
    Views
    245

    problem with my macro, please help

    Filename = ActiveWorkbook.Name
    SheetName = ActiveSheet.Name
    ActiveSheet.Name = Filename & " " & SheetName
    Rows("1:3").Select
    Range("A3").Activate
    Selection.Delete...
  12. Re: when i run this macro , im not able to use the personal in that sheet. help please

    thanks Holger . :)
  13. when i run this macro , im not able to use the personal in that sheet. help please

    Sub toopen()
    '
    ' toopen Macro
    '
    Dim objXL
    Set objXL = CreateObject("Excel.Application")
    With objXL
    .Workbooks.Open ("D:\B15-FATIGUE\models\optimized\sheet9.xlsx")
    .Visible = True...
  14. Re: macro to open a excel file, run a different macro( the one i already have)

    i meant separate 144 excel file
  15. macro to open a excel file, run a different macro( the one i already have)

    i have around 144 files, i need to run the same macro( the one i already have) in all of them. its very difficult to open it independently and run it. So is there any way i can create a macro to...
  16. macro to save a worksheet as txt with the same name as the sheet

    I have workbook will 7 sheets, i want to save all of them as txt file with the same name as the excel steel.
    as i am new to macro, it will be kind of you, if you could help me out
  17. Macro to rename multiple worksheets with the workbook name

    For example , consider a sheet name ABC_1, workbook name is XYZ.
    I want to rename the sheets to "XYZ ABC_1" . Is it possible? i need to do it to multiple files, please help. thanks in
Results 1 to 17 of 17