sheets.count

  1. S

    Insert 2 columns from 1 sheet to another using VBA

    This is the code i have worked with. It is showing the error 1004 that the copy area and paste area are not in the same size. Please help me with the issue? Sheets("ESTemplate").Activate Sheets("ESTemplate").Columns("A:B").Select Selection.Copy Sheets("Effort_Summary").Activate For j = 2 To...
    • Sukanya
    • Thread
    • area excel macro to copy paste excel macro vba sheetcount sheets.count
    • Replies: 3
    • Forum: Excel Questions
  2. M

    Marcro for copying rows below a table / database

    Hi All, I am new here, but have read a lot of topics about creating macros. I have created a macro for copying a selection to multiple worksheets (10). The macro is working, but I receive every time the following message from Excel: "Microsoft Excel found a row of data immediately above your...
  3. CsJHUN

    Sheets print header vba and an easer egg?

    Hi guys, Yesterday i had a job to make a vba to pagination. That was the working results. Sub sheetcounter() For i = 2 To Sheets.Count Sheets(i).Select Application.PrintCommunication = False With ActiveSheet.PageSetup .RightHeader = "&B &Kpch&J" & ActiveSheet.Index - 1 & "\" &...
    • CsJHUN
    • Thread
    • .rightheader centre end hungarian sheets.count
    • Replies: 1
    • Forum: Excel Questions
  4. W

    VBA - create new Sheet + fill data in cell based on list

    Hi, I have a VBA script running to add a new Sheet, fill it with a template (TEST Test2) and add the name of the specific employee based on a list. The employee data is located on worksheet RRAV, column K provides the name of the employee. What i want to do is populate cell B3 with the user...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top