Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-17-2018, 10:08 AM
14spar15 14spar15 is offline Create a sequence of numbers using a formula Windows XP Create a sequence of numbers using a formula Office 2000
Competent Performer
Create a sequence of numbers using a formula
 
Join Date: Mar 2011
Posts: 100
14spar15 is on a distinguished road
Default

What I need is a macro that I can run after data is entered into A1 and B1 and end up with the expected results in C1. The =ROW(INDIRECT(A1&":"&B1)) formula works fine if I run it manually but when I try to record the process into a macro I run into problems. The code that is in the recorded macro seems to be tied to the results of the A1 and B1 values that were used in the macro that was recorded so if I change A1 or B1 I do not get the expected results.
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequence numbers after each print MauricioPillon Excel 0 02-15-2018 08:11 AM
Create a sequence of numbers using a formula Wildcards - Sequence of Numbers at the Beginning of Each Paragraph qubie Word 1 11-30-2017 02:03 PM
How to assign numbers to letters and then create a formula to add them together for a rota Mskapri Excel 6 04-01-2017 03:05 PM
Need Help Deleting Numbers in Hour Format and Numbers in Sequence rsrasc Word VBA 1 10-12-2016 02:49 PM
How to Create a Locked Sequence of Buttons kcackin PowerPoint 0 01-24-2011 02:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft