how should I apply a formula and get answer in all the odd cells?

by

Guessing at what OP has not bothered to clarify, maybe, in A3 and copied down: 

=IF(ISODD(ROW()),A1+1,"")

More Related Contents:

  1. we want to search for an empty column and add items to that column using a vba form
  2. Excel: Consecutive 3 Occurrences or more of a value in a string
  3. Error in finding last used cell in Excel with VBA
  4. Excel VBA, getting range from an inactive sheet
  5. Is there a way to crack the password on an Excel VBA Project?
  6. How do I declare a global variable in VBA?
  7. How to use the Implements in Excel VBA
  8. VBA code doesn’t run when cell is changed by a formula
  9. What is the difference between dim and set in vba
  10. How to set recurring schedule for xlsm file using Windows Task Scheduler
  11. Change date format using substitute or replace
  12. How to export a CSV to Excel using Powershell
  13. VBA: Convert Text to Number
  14. Iterating through populated rows
  15. Using VBA to detect which decimal sign the computer is using
  16. Referencing Excel Userform Control Name Value From String (VBA)
  17. Loop through each row of a range in Excel
  18. Fill formula down till last row in column
  19. If string contains word from list, return value adjacent to list value
  20. Refreshing all the pivot tables in my excel workbook with a macro
  21. Countif With Multiple OR Criteria
  22. Vlookup to copy color of a cell
  23. excel vba freeze pane without select
  24. Converting a string representation of a constant into a constant?
  25. Macro to export MS Word tables to Excel sheets
  26. VBA WinHTTP to download file from password proteced https website
  27. Function Overloading and UDF in Excel VBA
  28. VBA Excel simple Error Handling
  29. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
  30. How to save semi-colon delimited csv file using VBA?

Leave a Comment